For the month of October we are offering a free add-on for anyone who purchases a Server Assessment from Stedman Solutions. From October 1st to October 31, with the purchase of server assessment, you will also receive for no additional charge 1 full year of our SQL Daily Monitoring product. If your assessment is for one SQL Server you will …
Receive a full year of Daily SQL Monitoring FREE Read more »
Here listed is the current percentages of SQL server versions running our Daily SQL monitoring service with Database Health Monitor. Compare this month’s percentages to Last Month’s Percentages What does this post mean?? We offer a service called SQL Daily Checkup. The pie chart above represents all of our current customers using this service and what SQL Server versions they are running. …
Daily SQL Monitoring – SQL Server Versions for June 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 to Last Month’s Percentages What does this post mean?? We offer a service called SQL Daily Checkup. The pie chart above represents all of our current customers using our service and what SQL Server versions they are running. What …
SQL Daily Monitoring – SQL Server Versions for March Read more »
Max Server Memory Setting Explained If you have more memory than your database and applications on the SQL Server will ever use than this is not a problem, but when you run into memory constraints this setting is much more important. SQL Server attempts to use as much memory as possible, and when there is no more memory available, SQL …
SQL Server Performance Tuning Tips – Wait Statistics Wait statistics are commonly overlooked ways to quickly find out what is causing your SQL Server to be slow. One of the reasons is it’s difficult to see how they are trending over time. >>> It is not difficult with a monitoring tool. <<< When someone reports a slow database yesterday at …
Today I had the pleasure of releasing Beta 9.3 of the Database Health Monitor. It has been a whole week since the last beta update, and here is the outline of the new features and bug fixes. Download at DatabaseHealth.com New Features New report, Partitioned Tables. This new report shows all of the partitioned tables in a database. Double clicking …
Now that Beta 2 of the Database Health Project is out, and people are using it, I am going to focus my attention on 2 areas. Fixing any bugs that are reported in Beta 2 of the Database Health Project. Adding new features, specifically related to offline monitoring or history data. Currently all of the reports in the database health project …
Now that Database Health Beta 2 is out, whats next… Read more »
I often get asked “how do I find the contents of the SQL Server Plan Cache?” My first response is just use the Database Health Reports and you can get this through a nice user interface. But if you still want to get at the Plan Cache contents, I use the following query. Again, the Database Health Reportsgives you a …
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 »