Picking the Right Instrument for SQL Server Performance Management

Do you know how well your large SQL Server environment is performing? If a problem arises, how long does it take you to diagnose it before you can fix it? Can you track trends and report on performance conditions? What about if you’re considering SQL Server 2008?

In Quest's new technical brief, Picking the Right Instrument for SQL Server Performance Management, Denny Cherry -- SQL Server expert and senior database administrator at Awareness Technology -- describes use cases and specific challenges for which Spotlight on SQL Server Enterprise was leveraged. Denny discusses how you can:

• Identify challenges while gaining a clear picture of what is going on in SQL Server
• Examine the challenges as they apply to SQL Server 2008
• Investigate different ways to address these challenges (e.g., utilities and native tools)
• Use Spotlight on SQL Server Enterprise to  quickly identify, diagnose and resolve performance issues