Search Results | SQL Server Performance Forums

SQL2005_DB_Performance_Slow

Post by: Sandeep_Das05, Aug 9, 2009 in forum: SQL Server 2005 Performance Tuning for DBAs

thank you rick....i need to check the above option too....

SQL2005_Query_Slow

Post by: Sandeep_Das05, Aug 6, 2009 in forum: SQL Server 2005 Performance Tuning for DBAs

Peethi, Yes, your information sounds good to me but i observed the io and execution plan for the same, i did n't see any clue for performance...

SQL2005_Query_Slow

Thread by: Sandeep_Das05, Aug 6, 2009, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

hi all, i found some of querys performing slow in database and i tried to analyze but it looks no increase in performance. for example...

SQL2005_DB_Performance_Slow

Post by: Sandeep_Das05, Aug 6, 2009 in forum: SQL Server 2005 Performance Tuning for DBAs

hi rick i can give a try to your points...as per my knowledge i think we have not more loads in test server...can you just roughly tell me one thing...

SQL2005_DB_Performance_Slow

Post by: Sandeep_Das05, Aug 4, 2009 in forum: SQL Server 2005 Performance Tuning for DBAs

hi rohit Both databases are same in all respect...Yes, the machine configuration are not same. In test server we have 4 GB ram and P4 Core2deo 2.80...

SQL2005_DB_Performance_Slow

Post by: Sandeep_Das05, Aug 3, 2009 in forum: SQL Server 2005 Performance Tuning for DBAs

hi rick, Pls find my answers for your queries. What is your schema (table and index definitions)? - its default "dbo" How many rows? - well i am...

SQL2005_DB_Performance_Slow

Thread by: Sandeep_Das05, Aug 1, 2009, 9 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

hi, in sql server 2005 test server one of database running slow, what are options i need to check..?? thanks