Tag Info

New answers tagged

3

If you are running SQL Server 2008 R2 SP1 and up then you can query sys.dm_server_registry to find out TRACE FLAGS that are enabled at startup. select * from sys.dm_server_registry where cast(value_data as varchar(max)) like '%-T%' Just incase if you or future visitors need the output in one row then, you can use below T-SQL : select distinct ...


1

I have been troubleshooting an issue within a database that has some serious blocking issues. I am just wondering if there is a way to see what variable is associated with the query. I would suggest, you should use either of below for troubleshooting blocking problems : You can use beta_lockinfo by Erland Sommarskog beta_lockinfo is a stored ...



Top 50 recent answers are included