Amazingly, even in SQL 2008 there's no performance testing/tuning GUI. But of course, you just need to know where to look to find free tools. Welcome to Codeplex.
SQL Nexus takes advantage of the SQLDiag command line tool that ships with SQL Server, sucking in DMV and Trace data to present in a great drill-through Reporting Services based interface.
Within an hour, I'd identified 2 hardware based issues with solid evidence to present to management.
Tip: Read the installation steps carefully; it's not an all-in-one install. Also, when directed towards a download of PerfStatsScript.zip, look here for the download.
Showing posts with label Tuning. Show all posts
Showing posts with label Tuning. Show all posts
Wednesday, September 10
Monday, September 8
Measuring Performance of Stored Procedures
Lately I've been faced with dual problems: how to spot which stored procs are performing the worst within an application which has been released, and secondly, how to help developers write code that runs quickly before deploying it to production.
Of course you can run Traces, or have a look into System Views, but knowing the how is a lot different to knowing the whiches, whens and whys. For example, which trace events do you enable?
This article by Preethiviraj Kulasingham at SQL Server Universe set off a few light bulbs for me.
Of course you can run Traces, or have a look into System Views, but knowing the how is a lot different to knowing the whiches, whens and whys. For example, which trace events do you enable?
This article by Preethiviraj Kulasingham at SQL Server Universe set off a few light bulbs for me.
Subscribe to:
Posts (Atom)