download the new version for iphoneMontezuma Blitz!

Preferences Preference cookies enable a website to remember information that changes the way the website behaves or looks, like your preferred language or the map you are looking at. The website cannot function properly without these cookies. Technically necessary Necessary cookies make a website usable by enabling basic functions like page navigation and access to secure areas of the website. We store the time and the selection of your consent anonymously under the identification stored in cookie 'ID'. Choose the type of cookies you're happy for us to use (you can change them anytime), or just accept.Ĭertain types of cookie are essential to use our site. Displaying advertisements could share information about your use of our site with advertising partners who may combine it with other information that you are provided to them or that they have collected from your use of their services. Include the version of sp_Blitz, your SQL Server version number (including the build #), and tag it with sp_Blitz.We use cookies to personalise content, to analyse our traffic, and to show advertisements.

Post a question at and the community (that includes us!) will help.

Talk with us in the #FirstResponderKit Slack channel (if you need a free invite, hit ).

Sp_Blitz works on SQL Server 2008 and newer, but if you use an older version, take heart: there’s an older sp_Blitz in the Deprecated folder of theFirst Responder Kit that still works in 2005.įor free interactive support, you’ve got a few good options: The sp_Blitz documentation covers additional parameters that will return more results, store the results to a table, and even output the results in Markdown for easy copy/pasting.

If there’s a warning you don’t recognize or understand, copy/paste the URL from the URL column into your browser, and I’ve written a ton of free documentation that explains the issue and how to get it fixed.

I like to joke that Priority 1-50 are the reasons why people get fired. It returns a prioritized health assessment with the most urgent issues at the top, like database corruption or missing backups: Once you’re comfortable with sp_Blitz’s speed, then you can remove that parameter and get even more advice on your system. That’s the fastest way to run sp_Blitz because it skips checking objects inside the databases, like heaps and triggers. EXEC sp _Blitz CheckUserDatabaseObjects = 0

Download the new version for iphoneMontezuma Blitz!