September 18, 2008 at 5:36 am
For monitoring SQL server performance counters, which tool is used ? Is it Performance Monitor under Administrative Tools ? Or any other tool is available or is their any other way ?
September 18, 2008 at 5:51 am
You can use SQL Server Profiler
September 18, 2008 at 6:22 am
To determine what's happening with the system, yes, you use Perfomance Monitor. For a detailed look inside the databases, to get individual query performance and behavior, then you use a trace. Don't use the Profiler gui to collect data.
"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
September 18, 2008 at 6:36 am
Don't forget there are a whole bunch of dynamic views and functions in SQL2K5 which can give you a lot of useful info.
sys.dm_exec_query_stats
sys.dm_exec_requests
sys.dm_db_index_usage_stats
sys.dm_db_index_physical_stats()
just to name a few... worth checking these out and others on BOL.
HTH
Kindest Regards,
Frank Bazan
September 18, 2008 at 6:44 am
Too true. You're right. I keep forgetting those things are in there.
"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 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply