Viewing 12 posts - 1 through 12 (of 12 total)
Expand the tables to search that one by one.
January 30, 2018 at 3:34 am
Y.B. (8/2/2016)
select
CONVERT(TIME, DATEADD(ms, DATEDIFF(ms, last_request_start_time, GETDATE()), 0), 114) AS Duration,
*
from sys.dm_exec_sessions
where (status <> 'sleeping' or open_transaction_count > 0)
order by...
August 2, 2016 at 8:47 am
And also, can I use performance counter "SQLServer:Access Methods - Table Lock Escalations/sec" as well?
July 22, 2016 at 7:08 pm
John Mitchell-245523 (7/22/2016)
Yes. Capture the lock_escalation event in an Extended Events session.John
Thanks, but how I can use SQL query to get this from Extended Events. The reason why I...
July 22, 2016 at 7:02 pm
Sergiy (7/21/2016)
There is dbid column in sys.dm_exec_sql_text
Thanks, but I can see most of the dbid are null value from sys.dm_exec_sql_text.
July 21, 2016 at 11:26 pm
I mean how I can query the SQL Server settings via SQL statement, e.g. maximum degree of parallelism?
July 12, 2016 at 2:08 am
TheSQLGuru (7/5/2016)
Download a copy of Glenn Berry's SQL Server Diagnostic Scripts for your version of SQL Server. An AMAZING collection of free stuff there!
From Glenn's script, I can find the...
July 8, 2016 at 7:17 am
johnwalker10 (7/7/2016)
select left(name, charindex('_',name)-1)
from tempdb..sysobjects
where charindex('_',name) > 0 and
xtype = 'u' and not object_id('tempdb..'+name) is null
Thanks, and if I would like to know the top 10 temp tables and...
July 8, 2016 at 1:06 am
Viewing 12 posts - 1 through 12 (of 12 total)