I'd like to determine if all my threads are used up and preferably monitor this somehow. We're running 4 instances LLcluster currently - Eng, Fre, Admin and one for LAPI-connected applications. 6 thereads per each. I don't really understand what does threadstatus report tells me, what tasks...
Here is the easy T-SQL code that I use to get hierarchical data from Dtree.
CREATE PROCEDURE DBO.sp_GetLLChildren
(@ParentID int = 2000, @Subtype int = Null)
AS
DECLARE @Level int
SET @Level = 0
SELECT DataID as DataID, @Level as ChildLevel INTO #T FROM dbo.Dtree WHERE ParentID =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.