Search Results | SQL Server Performance Forums

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...

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

Post by: greg.balajewicz, Aug 24, 2009 in forum: SQL Server 2005 General DBA Questions

Thank you all for your responses! I thought that breaking up a database to number of files equal to the number of physical CPUs yielded better...

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...

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

Post by: greg.balajewicz, Jul 30, 2009 in forum: SQL Server 2005 General DBA Questions

OK, thanks! I take it then that I should not expect performance improvements by going to simple recovery model. I did a test on my poor, I/O...

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....

New server setup question - disks

Post by: greg.balajewicz, Jul 29, 2009 in forum: SQL Server 2008 Performance Tuning for Hardware

well, most articles suggest wither RAID 10 OR RAID 0 for tempdb. I don't have a raid 0 volume available so my choice is: (a) put temp db on RAID 10...

New server setup question - disks

Post by: greg.balajewicz, Jul 27, 2009 in forum: SQL Server 2008 Performance Tuning for Hardware

yes, i am using 64 bit os and sql server. No chance of having 2 servers however - asp.net and sql must be on the same machine for now. I am concerned...

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....

Sql Server not using all RAM...

Post by: greg.balajewicz, Jul 27, 2009 in forum: SQL Server 2008 Performance Tuning for DBAs

thanks guys! i am actually not new to the forum but I could not recover the password to my login! :) Anyway, yea, the IO is definatelly an issue (I...

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...