August 24, 2007 at 8:44 pm
Hi,
My database is using nearly 150 users today morning some of the users are complaing my database performing very slow result & respose.
How can increase the my database Performance what are ther steps i can follow to increase the my database performance please guide me & plz give some more good suggestions plz
URGENT
August 26, 2007 at 8:27 pm
1. Perfmon
2. Profiler
August 27, 2007 at 8:05 am
If it's sql 2005 sp2 then you can use the microsoft performance dashboard which will show you all sorts of good stuff like the queries using the most cpu, io and time. It's easier to use than perfmon and profiler and it can often provide tips on indexing. You may still need to get into profiler, perfmon and reviewing execution plans but this is a good start if you are not familiar with these tools. If you are not using sql2005 sp2 then you will need to use profiler to identify the queries using the most resources.
August 27, 2007 at 10:06 am
Sounds like you are new to performance monitoring. I strongly recommend getting a consultant for an hour or two of time to connect up and help you out. You will be wasting a LOT of time and effort otherwise.
Failing that, run sp_who2 active during slow-perf times and check the blkby column. Read up on blocking in Books Online.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply