Add an index to Alert.Alert on AlertType to remove index scan

Here's the index. It really helped speed up the system (monitoring 20 servers)

USE [RedGateMonitor]
GO
CREATE NONCLUSTERED INDEX [AlertType]
ON [alert].[Alert] ([AlertType])
INCLUDE ([AlertId])
GO

3 votes

Phil Grayson shared this idea · Dec 4, 2014 · Report… · Admin →

declined ·

Daniel Rothig responded · Dec 17, 2015

Closing as it’s being tracked as a bug – thanks Phil!

An error occurred while saving the comment

Phil Grayson commented · March 17, 2015 10:23 AM · Report

Thousands as it was a large, established deployment that hadn't had the level of insight you get from SQL Monitor.

Submitting...
AdminDaniel Rothig (Admin, Red Gate Software) commented · December 4, 2014 4:43 AM · Report

Hi Phil,

Thanks for this - we're planning to investigate performance issues sometime next year, and I'll make sure we look into this index!

Out of curiosity, how many rows are there in alert.Alert on your installation?

Submitting...

In Redgate Monitor, I want to...