thank you!!!! exactly what i needed it. 😀

i did it with the criteria of 40 and started firing one after the other, that's why i was asking you what would be a good number.

so a good value is above 40?

thank you!! which criteria is best? do you have an alert for every single counter?

DO YOU PUT THIS IN A JOB?

i tried running this script , right click and click in output to text but i get this error

Msg 213, Level 16, State 7, Line 4

Insert Error: Column name...

is there any way to create an alert when there is locks?

http://msdn2.microsoft.com/en-us/library/ms191168.aspx

let me know your thoughts please.

thank you!! 🙂

hi thanks for the link, i tried doing the article before but some of my servers are in the network but are not part of the domain. how do i...

thanks but how do i use this script to run against my other servers?

I need to be able to create ssis packages stores on another server, or interact with the file system on a network share. I have Database Mail not sql...

thanks for your quick answer, i have many other servers some in my same domain some in others, so i need a domain account correct? this account should be created...

hi run your script but i get this error message

Msg 7202, Level 11, State 2, Procedure cp_diskspace, Line 22

Could not find server 'WIN2K09' in sysservers. Execute sp_addlinkedserver to add the...

hi David if you figure it out can you please post the answer, i have been trying to figure it out for days now. i got a similar code from...