SQL Server Performance

Search Results

Search Again
  1. greg.balajewicz

    How to find out what querry is a bottle neck, what is taking most time and resources?

    Thread by: greg.balajewicz, Aug 24, 2009, 4 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    Hello everyone! I got an OLTP system (for www.realmofempires.com) which I am trying to analize. It appear the SQL server takes the bulk of CPU...
  2. greg.balajewicz

    how to: break up a database into multiple files (for performance)

    Thread by: greg.balajewicz, Aug 12, 2009, 5 replies, in forum: SQL Server 2005 General DBA Questions
    Hello! What I want to do: I have a single database, about 5gb that uses a single MDF datafile. I want to break it up to 4 files (see why below) I am...
  3. greg.balajewicz

    do full backup every 30 min and use simple recoverty OR full recovery with daily full backups - What will yield best performance?

    Thread by: greg.balajewicz, Jul 29, 2009, 3 replies, in forum: SQL Server 2005 General DBA Questions
    Hello everyone !! I have an application and can live with 30 min of lost data. ie, if catastrophic failure occurs, last 30 min of data can be lost....
  4. greg.balajewicz

    New server setup question - disks

    Thread by: greg.balajewicz, Jul 27, 2009, 5 replies, in forum: SQL Server 2008 Performance Tuning for Hardware
    Hello everyone!! I am not a DBA but have a bit of experience with administering SQL Server 2005 and now need to decide on hardware for a new server....
  5. greg.balajewicz

    Sql Server not using all RAM...

    Thread by: greg.balajewicz, Jul 26, 2009, 4 replies, in forum: SQL Server 2008 Performance Tuning for DBAs
    Hello, I am a bit surprised that my sql server does not use full 16gb of ram with 3 very active database of 6gb each.... When the server/service is...
Showing results 1 to 5 of 5
Search Again