Wednesday, 20 April 2016
Subscribe to:
Comments (Atom)
SQLDBA- SQL Server Wait Events
To solve slowness of SQL Server database, you should find which wait events exists in the database. You can find wait events of database w...
-
Script out the Linked server objects. CREATE PROCEDURE [dbo].[win_linked_server_objects_extract_select] AS /************...
-
-- Health and status of WSFC cluster. These two queries work only if the WSFC has quorum SELECT * FROM sys.dm_hadr_cluster SELECT * FROM sy...
-
Start-Transcript - path C:/Script/PingLog.txt -Append Ping.exe -t spiceworks.com | ForEach { "{0} - {1}" -f (Get-Date), $_ } ...
