Hi Andrew,

The problem with redundant indexes, like ins_ypsI2, is that there is additional overhead for data updates but no benefit for selects.

The script below will find all redundant indexes in...

Here are a couple of scripts that make the numbers more useful.

The first gives you all counters, including absolute values (like page life expectancy), percentages calculated by dividing a counter...

Hi Jeff,

I am aware of your slide set on the subject and I agree with what you say.

Some comments though:

You assume an attacker with the skills to obtain SA...

You can do this with PowerShell.

And if you have xp_cmdshell enabled (not encouraged for security reasons) you can run it from an SSMS Query window.

exec xp_cmdshell 'powershell.exe -noprofile -command "Get-WmiObject...

I suspect the person who told...

There is no harm in doing that, with a couple of provisos:

Be aware of potential performance issues - each query will run one at a time; they are not submitted...

Rewritten to get the xml from a variable, but you should be able to apply this logic to your situation:

declare @x xml

select @x = '

<Artists>

<ArtistText>Genie Zhuo</ArtistText>

<Artist Type="Main">

<FullName>Genie Zhuo</FullName>

</Artist>

<Artist Type="Secondary">

<FullName>The Second...

For IOPS you need to look at the Physical Disk Reads/sec and Writes/sec.

Brent Ozar wrote a post over 6 years ago about how to capture these values and use Excel...

So you want to measure IOPs without looking at performance counters?

Or you want to measure max IOPs that the storage is capable of, but without using SQLIO?

What is wrong with...

Haha - perfect.

Thank you for writing this; one of the most interesting articles I've seen for...

In my experience, the network is very rarely the cause of poor performance. When it appears to be the network it is more often one of the following: