Hi,

There are lot of things need to be monitor if the usage leads to 100%.

--run the below script which gives longest running queries list.

Try to modify the top most...

Hi,

I'm searching for past couple of days, can you kinldy share the script which sends a notification when ever sql server restarts.

Kindly help me...

Regards,

Venkat