As part of the Database Health Monitor version 2.1 release there were many new report includes, one of those was the backup status report. A quick way to page through all of your SQL Servers and check on the status of backups. Here is an example of the backup status report showing a database that hasn’t had any recent backups, …
Being the middle of the summer in the northern hemisphere, and with the Database Corruption Challenge over, I thought I would cover something a bit lighter, and not as hard core as database corruption. Share Your DBA on Vacation Stories If you have been a DBA for more than a year or two you probably have some story about going …
When you are looking for deadlocks there are, like most things in SQL Server, more than one way to find the deadlocks. This article is specifically focused on using the SQL Server ERRORLOG file located in the LOG directory for the SQL instance. If you used the defaults on SQL Server 2012, this log would be at this location: C:\Program …
The new Joes2Pros Academy has just launched. The Academy provides an interactive classroom experience that can be accessed on your own time as you need it. This site has high quality content, quizzes and exams. Students can interact with other students and instructors to get the best experience out of the Joes2Pros Academy. Courses offered in the following areas: SQL Server Administration SQL …
On my computer I run SQL Server 2012, and I use a number of test or development databases. I don’t run backups on these because I don’t care if they get destroyed since they are easy to replace. Recently I upgraded to a SSD, and now my C:\ drive which I am running SQL Server from is really fast, and …
Shrinking a Log File on a Test or Development Server Read more »
Beta 2 of the Database Health Reports has just been released. The new Beta contains several bug fixes, and several new features. Here is a breakdown of what is new or changed since the last beta. New Features Added the Memory by Database panel to the Database Overview page. Added the Memory by Database report. Added Unclustered Tables Report. Added the Connections Advisor which is linked to …
Although clustered indexes are not required, and there are many cases where you should not use a clustered index, quite often clustered indexes can be overlooked when creating a table. This is actually more likely if you are inheriting a database from someone else who didn’t know enough about indexes. In these cases adding the right clustered index can dramatically …
Finding tables that don’t have a clustered index. Read more »
In SQL Server 2012, there was a change to the dynamic management view that reports on the plan cache, so the query has changed. Here are the before and after queries to determine the plan cache size in SQL Server 2012, and prior to SQL Server 2012. SQL 2012 Plan Cache Size Pre-SQL 2012 Plan Cache Size For more details …
After rebooting a SQL Server, for whatever reason, it is always good to confirm that the system is running good. There are many things that I check, one of which is to confirm that backups are running. You can always go to the server browse to the various directories holding backups, and check on the latest files. This can be …
Working on a new report for the SQL Server Health reports, I needed to display the amount of free disk space on a SQL Server. EXEC MASTER..Xp_fixeddrives; Which was useful if I just wanted to look, but I needed to use the results in a query, and I didn’t want to put the results into a temp table, so here is …