September 3, 2009 at 9:59 am
Just wondering what can be used to collect data regarding performance and SQL Server. How can you measure the internal performance of SQL Server? How can you collect some data to graph and evaluate? Any free tools available? Anything in SQL Server available? Any thoughts appreciated.
September 3, 2009 at 10:14 am
sys.dm_os_performance_counters would be a good place to start.
And then it depends on what your needs are as to which counters to study and graph.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 3, 2009 at 11:56 am
Just presented on this yesterday during 24 Hours of PASS.
Perfmormance Monitor: free, built into to Windows, useful for monitoring server and SQL Server at a strategic level
Trace Events: free, built into SQL Server, useful for monitoring SQL Server at a very tactical, command level
Dynamic Management Views: free, one mentioned above, you can gather both strategic and tactical information
Data Collector: free with SQL Server 2008 (maybe Enterprise, not sure), strategic and tactical useful out of the box.
Knowing which counters to monitor is the hard part. There are lots of good articles out there on this and quite a few books (look down).
"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 3, 2009 at 11:56 am
PerfMon has a slew of stuff built-in for SQL Server 2005.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply