how to monitor performance of SQL server

Last Post 18 Feb 2013 04:51 AM by unicos. 5 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
unicos
New Member
New Member

--
07 Feb 2013 03:22 AM
I have been asked to monitor SQL Server (2005 & 2008) and am wondering what are good metrics to look at?
also suggest how to improve it ?
rm
New Member
New Member

--
07 Feb 2013 05:39 AM
It's big topic, you can check Quest, Idera, red-gate or so for sql monitoring tools.
spiral98
New Member
New Member

--
08 Feb 2013 03:31 AM
Start with monitoring essential system performance counters like:
1. Cpu load
2. Page fault
3. Disk r/w queue
4. Disk r/w time
Check out the link to monitor SQL server performance using performance monitor
http://www.sql-server-performance.c...r-general/
unicos
New Member
New Member

--
12 Feb 2013 03:46 AM
Monitoring tool will be the 2nd option but it is great that you are suggesting some
gunneyk
New Member
New Member

--
13 Feb 2013 07:29 AM
I would suggest looking thru the acchives of the magazine for articles related to performance monitoring & tuning. Two DMV's that you should definately have a look at are the File Stats and Wait stats DMV's. sys.dm_os_wait_stats and sys.dm_io_virtual_file_stats. These will give you a pretty good look at how the physical I/O is doing and what if anything the system as a whole may be waiting on. There is tons of good info on each.
unicos
New Member
New Member

--
18 Feb 2013 04:51 AM
The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic snapshots of current performance to isolate processes that are causing problems, and gathering data continuously over time to track performance trends.
try this for better monitoring

http://www.mssqltips.com/sqlservert...onitoring/

http://www.sqlserverperformancemonitoring.com/
You are not authorized to post a reply.

Acceptable Use Policy