Sql Server : What is the recommended limit for Maximum number of connections allowed or max worker threads

Posted by Sqltimes
On September 26, 2015
0 Comments

Interesting Topic Today: In general sense, we know that, internally within operating system, any work is performed using worker threads. Similarly, Sql Server relies on Windows Operating systems thread services to perform work; Each running query has a separate thread. When we have a large number of client requests, assigning a dedicated thread to each request […]

Posted by Sqltimes
On September 19, 2015
0 Comments

Quick one today: Frequently, need arises to check what is running in some of the SPID’s on your Sql Instances. As always, with Sql Server, there are several approaches to this. Use case: One necessary and unavoidable fallout of concurrency is locks and latches. To maintain data integrity, Sql Server employs some internal structures to serialize […]

Posted by Sqltimes
On September 12, 2015
0 Comments

Quick one today: A few days ago, this script came in handy when a certain thread needed to be cleaned on a lab server. 1 2 3 4 5 -- -- Kill a SPID -- KILL 52 GO Sometimes such a command could take a long time depending on the payload of the SPID that […]

Posted by Sqltimes
On September 5, 2015
0 Comments

Quick one today: Sometimes, we end up in situations where we need to uncover the underlying lock escalation or lock assignments due to some query executions. In these situations, we have an internal system procedure that displays this information in great detail. Locks help attain concurrency, but they are expensive to maintain. So Sql Server […]

Sql Server : What is the recommended limit for Maximum number of connections allowed or max worker threads

Sql Server: What is running in my SPID?

Sql Server : How to KILL a SPID and then check the status of KILL / ROLLBACK progress

Sql Server: All the locks held by a process