Notes from SQL Server Classes
With the server overview page you can keep close tabs on some of the key performance indicators for a SQL Server. The details on this page apply not to a single database, but instead to the entire SQL Server instance. The server overview page gives you a quick rundown of the following: Historic Waits Plan Cache CPU By Database Server …
The I/0 By drive report gives you an overview of how much I/O each drive holding database or log files is using. Here is an example showing the IO by drive for a SQL server with no databases on the C Drive, and the load split between the E, F and G drives. The image below shows a SQL Server …
The I/O By Database report is one of the instance level reports available in Database Health Monitor. The I/O by database page shows the databases with the most IO on your system. This can be used to track down performance problems. You can get to this report either by right clicking on the instance name, and choosing instance level reports, …
The waits by type for instance page shows you the most commonly occurring waits on your SQL Server. Grid Columns Row: Just the row number in the grid. Type: The name of this wait type. Wait Seconds: The total amount of time this type of wait has been waiting since SQL Server was last restarted, or since the wait stats …
50% OFF Our Newest Course! Coupon Code: FEB-RELEASE50 Using our instruction and scripts included in this course you will successfully configure email notifications when blocking occurs. Address blocking BEFORE it takes down your system. >>> Link to Course <<<
10 Days of Reports with Database Health Monitor Day 2 – Table Size The Table Size report shows you the tables that are using the most disk space in your database. Many times, I’ve discovered a table in a SQL Server database that someone wanted to use to store files. That table was up taking up 98% of the entire …
Track Blocking Queries Course Release! Using our instruction and scripts included in this course you will successfully configure email notifications when blocking occurs. Address blocking BEFORE it takes down your system. Enroll in this course for $24.99 >>> With Coupon Code >>> FEB-RELEASE50 Picture This Scenario Your SQL Server runs into blocking but you don’t find out until it is …
25% OFF SQL Server Backup and Recovery Course Coupon Code: BACKUPFEB Expires: February 28th at 11:59pm This complete course will help you determine if you have a sufficient backup strategy and restore plan OR it will help you build one from scratch. >>> Go to Course Page
New Stedman Solutions Online Course Coming Soon! What is the course about? I thought you’d never ask! Our new course will teach you how to track blocking queries on our SQL Server. This course will be released sometime early next week and more details will be shared then. But for now….. Check out our Backup and Recovery Course on sale …
25% OFF SQL Server Backup and Recovery Course Coupon Code: BACKUPFEB Expires: February 28th at 11:59pm This complete course will help you determine if you have a sufficient backup strategy and restore plan OR will help you build one from scratch.