Great stuff guys,

Thanks a bundle ! What I did notice though is that sp_spaceused often shows some index usage when queries using the index ID (0,1) don't.

Would that be...

update: can't find any guidance on the required files on the root directory... Anyone have any experience on this ?

About the DNS issue,

How is your network configured ? Do you use fixed IP's for your nodes or do they get one from DHCP ? If fixed, you might have...

We might be able to help you better if you provide the error details ?

First thing to do is to check the details of the error 😉

Otherwise WMI is quite sensitive to security policies so ask you AD/server team for any policies they push...

@ Anthony: Our SCOM instance is plugged in to ANGate, that on its turn generates alerts an a ticketing system.

@ Perry: For now, it would suffice to simply receive alerts...

Just to make sure the file isn't in use by another process it might be a good idea to download handle.exe from sysinternals.

If the file is in use you can...

Still had this one between my favourites...

http://blogs.msdn.com/b/chrissk/archive/2008/06/19/i-o-requests-taking-longer-than-15-seconds-to-complete-on-file.aspx

Hope it's ok to just post a link.

Update:

Apparetntly there's the 'source log shipping server' and 'destination log shipping server' monitor in the SQL Server MP for SCOM.

Still there seems to be no way to check whether this...

Hi Quackhandle,

You have to import the MP's into SCOM so I think that's a no-go.

My question though is;

Is there way to monitor individual SQL Server jobs ? I only...