Monthly Archives: December 2014

Last “Touch” on each Database per Instance

Originally posted on cms4j:
Today i was asked if some of the databases on a specific instance were in use or not. As this is an interesting question that could be easily answered by the SQL Server DMVs i…

Posted in Uncategorized | Leave a comment

Blog Post Series „How to tune ISV apps“

Inspired by Brent Ozars Blog post http://www.brentozar.com/archive/2014/12/whos-allowed-add-indexes-isv-apps/ I will start this series. It will consist of: Capture the workloadCapturing a typical workload during business hours. Diagnosis and Doing with “sp_BlitzIndex™”Diagnose and Delete/Alter/Add Indexes with the help of Brent Ozars “sp_BlitzIndex™”. … Continue reading

Posted in SQL Server | Tagged , , | 1 Comment

Is SQL Server under high Memory Pressure?

A few weeks ago, i started a blog post series that covers the finding of performance bottlenecks in SQL Server. In the first blog post in the series https://cms4j.wordpress.com/2014/09/30/is-sql-server-under-high-cpu-pressure/ i focused on CPU Pressure. In this blog post i will … Continue reading

Posted in SQL Server | Tagged , , | Leave a comment