This is a piece of code I use to determine the last known good DBCC CHECKDB being run against a database. I’m surprised this information is so tricky to find. I’d expect it to be sitting on the database properties tab right under last known full backup. but it’s not. Instead it is listed as a database Info property, and we need to jump through some hoops to find it.
Read More →Category: SQL Server
Optober – SQL sp_configure Options – Priority Boost
Optober rocks on today with a quick post on Priority Boost. I hadn’t planned to deal with this one until much later in the piece, but I’ve been reviewing a very unstable server for a client today, and it tracks back to this option. It’s another one of those things like ‘autoshrink’ which sound like […]
Read More →Optober – SQL sp_configure options – Optimise for Adhoc Workloads
Optober continues with more sp_configure option descriptions. This time it’s all about Optimise for Adhoc Workloads. This is an option that I never had much to do with until I discussed it with a colleague who uses it as a default install option. That got me to thinking….
Read More →Optober – SQL sp_configure options – Allow Updates
Option Name: allow updates Usage: sp_configure ‘allow updates’, 1 Default: 0 Maximum: 1 Requires Restart: No What it does: Once upon a time if you wanted to update system tables in your database you could do so, and this was the magic switch you needed to throw to do it. In the current enlightened times people […]
Read More →Optober – SQL sp_configure Options – Remote Admin Connection
On about day one of being a DBA I was told this was an option that should always be enabled. It took me much longer to understand what it achieved, and over 5 years before I had to use the dedicated administrator connection ‘in anger’. But if you use it once and save having to reboot a server, you will come to appreciate it very quickly.
Read More →Optober – SQL sp_configure options – Backup Compression Default
Optober continues with more sp_configure option descriptions. This time it’s all about backup compression default. I was surprised today when doing a review that a client was still under the impression that backup compression was still an enterprise feature. No no no no no. It’s there for everyone with standard edition since SQL Server 2008 R2 and there’s really no reason not to be using it.
Read More →Optober – SQL sp_configure Options: Show Advanced Options
It’s Optober – a time to look at all the SQL Server sp_configure options and figure out what they do and why they are there. In this post we look at ‘show advanced options’, just incase anyone can’t figure out what it does from the name.
Read More →