Session Details -
How are my Servers Today?
|
|
If you wish to maintain your Production SQL Servers and Databases then you need to be proactive - this means you need to collect and trend performance data to be able to recognise a problem before it fully manifests itself.
Understand your work patterns - detect trends - identify potential problems - keep your manager happy with performance and trend reports.
The Performance Dashboard was a start for sql 2005 and sql 2008 has the start ( RC0 ) of a built in dashboard. This presentation will walk you through how to collect real time data and what you can do with it when you have it. We'll also show how to create graphical dashboards in SSRS 2005 and SSRS 2008 and how to make use of the data. ( the source system can be sql 2000 - sql 2008 )
|
|
|
Colin Leversuch-Roberts
|
|
|
|
aka GrumpyOldDBA www.grumpyolddba.co.uk. Worked with SQL Server since 6.0 Production DBA who tends to specialise in server and application performance tuning.
|