Hope below blog helps

https://blogs.msdn.microsoft.com/deepakbi/2010/04/13/monitoring-tempdb-transactions-and-space-usage/

If you are lucky enough,we can now get deadlock information from system health session without any additional tracing .Have a look at below great article :

http://www.sqlservercentral.com/articles/deadlocks/65658/

No luck with Win32_Product as well 🙁

If you have the latest patches,then problem is due to high VLF count.

You can find out the VLF's count using below command

dbcc loginfo('databasename');

http://blogs.msdn.com/psssql/archive/2009/05/21/how-a-log-file-structure-can-affect-database-recovery-time.aspx

FIX: It takes a long time to restore a database in SQL Server 2008 R2 or in SQL Server 2008 or in SQL 2012

https://support.microsoft.com/en-us/kb/2653893

Thanks for the reply.Unfortunately there is no log(date attribute) which tells us when registry key was created or edited

Thanks a lot..Above trigger did the trick:-):-):-)

Thanks again for suggestions.But in our SQL estate,we have some application which create their own databases & also I would like to restrict my co-DBA's also mistakenly creating database on...

Thanks for the replies..Unfortunately I could not find any Server Facet to restrict this.I think we can create a Server trigger(for create database) & check Drive info using EVENTDATA()...

Thanks:-)

I am new to PS.Is there anyway we can tweak the above code to pick serverlist from SQL server table and update the version information on same table

Cheers

Thanks Jack Corbett:-)The 2nd script helped me to find the user who dropped the permisssion:-):-)

Hey..I have one question..what happens if any of the server mentioned in the server list is down?I cannot test it by bringing one of the server down;-)

The modified script worked for me....:-):-)Thank you very much 🙂

Thanks for the quick response..:)

I tried to implement the same. lastRebootDate column for all servers is updated with the reboot time of first server in the table

Srv ...

Thanks for your reply:-)Very useful script..:-):-):-)

The code is showing the SQL server service restart date & time. But I am looking for server reboot time?Is it possible to tweak the...