SQL Server Performance Forum – Threads Archive
Performance Audit on SQL 2005
Does anyone have a link to a white paper or website with information on conducting a performance Audit in SQL 2005?What do you mean by a performance audit. Is it to check whether your db is good for the performance. —————————————-
How about this one, from this site’s very own Brad McGhehee:<br /><br /<a target="_blank" href=http://www.sql-server-performance.com/sql_server_performance_audit.asp>http://www.sql-server-performance.com/sql_server_performance_audit.asp</a><br /><br />Hey Brad!! <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br /><br />SQLGuru
You can use Brad article. You have to change Query Analyzer for Sql Server Managment Studio and ITW for Database Engine tunning Avisor.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS†with no warranties for accuracy.
By performance audit I mean how is my server performing (more OS based) over a specified period of time, say the last month. Average CPU, Disk Usage, buffer cache, disk queue, etc. I do not have access to performance monitor on the server in question, so I was hoping to leverage some of the new reporting functionality that seems to be included in SQL 2005. So far I’ve only been able to find "real time" performance numbers/reports (top CPU users, memory use, etc) and not much in the way of historical or trend data (average cpu over last 2 weeks). I’m on a tight timeline and don’t have the time to do the research myself so I was hoping someone had a SQL 2005 centric process that I could "borrow/steal".
Diagnostic Manager from Idera is a very good tool.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS†with no warranties for accuracy.
No $$$$ to buy a tool.
quote:Originally posted by dtipton
By performance audit I mean how is my server performing (more OS based) over a specified period of time, say the last month. Average CPU, Disk Usage, buffer cache, disk queue, etc.
I do not have access to performance monitor on the server in question, so I was hoping to leverage some of the new reporting functionality that seems to be included in SQL 2005. So far I’ve only been able to find "real time" performance numbers/reports (top CPU users, memory use, etc) and not much in the way of historical or trend data (average cpu over last 2 weeks).
I’m on a tight timeline and don’t have the time to do the research myself so I was hoping someone had a SQL 2005 centric process that I could "borrow/steal".
Depending on whether you want to take the hit, you could look at the system views to see what’s happening at a point in time, and then log that info to your own tables. NOTE: I haven’t tried doing this – it’s just a thought. for example, review:
select * from sys.dm_os_performance_counters
select * from sys.sysperfinfo and see if that helps a bit Panic, Chaos, Disorder … my work here is done –unknown
Thanks I’ll give that a shot.
]]>