Keep in mind that unless you test restore the files - you have no backup.

On the server with the CPU spikes, please check the BIOS settings for Energy Saving features.

If enabled, disable them.

sotn (1/14/2013)

---

I think this is fixed.

We have found that the CPU settings in the bios were set to balanced

Thanks SQLRNNR for the pointer.

A 'real' workload before changing the setting now...

Indianrock (1/14/2013)

---

I was given a document outlining the installation of the BMC Patrol for sql server 4.3.2 agent ( 2009 ), which is to be installed on the monitored servers....

Ok, that makes sense then.

What should the output look like?

Here is a similar thread. See if it helps.

http://www.sqlservercentral.com/Forums/Topic439890-149-1.aspx#bm440689

You need to explore the tape index/catalog/contents to see if the files were backed up. Better yet is to test restore from tape.

From what I gather it is more geared to the OS rather than SQL server. If you need to have purchased software to monitor, I prefer to stick with...

In parameter properties, go to available values. You set the label on this screen.

That would be great. It would be great if on the occasions that vendors do publish something, they would...

Glad we have this feature added.

Yes you can do that.

It sounds like you use drop boxes for each parameter. In the properties there is a label field. I add that Parameter label to...

I would never give any of my social media accounts to somebody else.

Change your order by to Avg Physical Reads. The Total Avg in that query has physical reads plus logical reads.

Starting with IO is a good start. ...