February 12, 2011 at 6:56 am
Hi All,
if any user complaints us that he is experincing slow performance in excuting their queries, what options we need to check....?
Usually, I check network between DB server and the query executing server, blockings and Indexes fragmentation.
Is there anything I am missing ?
Thank You.
Regards,
Raghavender Chavva
February 12, 2011 at 8:22 am
There are just tons of things to check. It's extremely rare for it to be the network. Most of the time, it's a badly written piece of code, or there's a problem in the structure in the database. After that, it could be contention on resources, usually evidenced by blocking, although again, that's frequently an indication of bad code or structure. I tend to focus most efforts in code & structure. Once you absolutely know those are OK, then you branch out and start drilling down in other things like rebuilding indexes or worrying about the infrastructure of the system. In general, if there is a network issue, you'll hear about it from more than one user.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply