In specific, its happening cause on of one job is running now Same here, my Sql manager freezes and I get that error. JOIN sys.dm_exec_requests d2 ON d1.session_id=d2.session_idĬROSS APPLY sys.dm_exec_sql_text(d2.sql_handle) d3 SQL Server uses over 10GB of memory on our production server at work, but that server has 32GB installed. Once you have that, you can query sys.dm_exec_sql_text() to get the actual statement(s) the user was executing (see example below).Īs for memory usage by SQL Server, that is dependent upon many variables size of database, number of databases within SQL Server instance, database utilization and query performance among others. When you know performance is suffering and see (within Activity Monitor) that a session is blocking query the sys.dm_exec_requests to get the sql_handle for the user causing the blocking. That will show you the memory & cpu usage, and whether any blocking/locking is occuring. You can use Activity Monitor (under Management node in explorer) to quickly view resource usage among each user connections.
I've never seen that error occur when expanding nodes within Object Explorer.
0 kommentar(er)
