If you are noticing a number of waits showing up on your SQL Server of type PREEMPTIVE_OS_GETPROCADDRESS and it is linked to the system procedure xp_delete_file the you may want to look at your backup cleanup jobs. Lets take a look at what you may actually be seeing – see image above What is shown in the image above is …
Xp_delete_file and Preemptive_Os_GetProcAddress waits Read more »
I am working on a big update to Database Health Monitor that I expect to release near the end of the year. So far I am sharing the beta with a few people to try it out before it is ready to release. Here is a list of some of the changes. Licensing Changes There are some licensing changes in …
As the DBA, you get a call from the IT Team who monitors disk space and they tell you the following: “One of our server that has SQL Server running on it is running low on disk space. It has gone from around 60% disk utilization to 95% disk utilization just overnight. Whats the problem?” In this scenario it’s a …
Technical Debt is a programming concept that is also known as code debt. The concept of Technical Debt applies closely with Agile software development, but also applies to database development. There are many tools available to report on technical debt for C#, PHP or other programming languages, but there isn’t much available to manage the SQL Server or T-SQL technical …
Thousands of people are using Database Health Monitor but there can be a learning curve. So we’ve come up with a way to speed up the learning curve. You will learn most everything that you want to know about database health monitor in just one place. This course is $39.99 and worth every penny. Below is the Curriculum details:
Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor. Compare this month’s percentages to Last Month’s Percentages
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 »
Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor. Compare this month’s percentages against Last Month’s Percentages
Learn how Optimize For Ad-Hoc Workloads can save some space in your plan cache. Transcription: Steve Stedman 0:09Hi, this is Steve Stedman and I’m here to talk about daily checkup or database health quick scan items that we come across occasionally. These are settings that we optimize or configure on the SQL Server in order to help with performance. Usually, …
Cost threshold for parallelism and the max degree of parallelism ( maxdop ) are 2 important setting for your SQL Server. Find out how to set these and what they should be set to. Transcription: Steve Stedman 0:09Hi, this is Steve Stedman and I’m here to talk about a couple of the daily checkup or database health quick scan items …