Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Processor Queue

    Make sure you acount for all the disk drives. The formula would be: counter / (drive count) < 2. if > 2 for > 10 min then there may be...

  • RE: Query runs slow as Stored Procedure

    Below is a portion of sp. @COLLECTOR_ID is the culprit. If I replace the variable with a hard coded value it runs quickly.

    CREATE PROCEDURE dbo.ABT_Select_Collector_LastWorkDate_NotReviewed

    --Add Parameters Here

    @COLLECTOR_ID ...

  • RE: SQL Server Performance Counter Lost

    I have an instance of SQL 2K SE SP3 and I cannot get the SQL Counters back into Performance Monitor. I read the knowledgebase article (#812915) relating to this issue....

  • RE: Transact-SQL Debugger

    I have similar behavior when I run the debugger from a remote machine. When I logon directly to the machine using terminal services or dameware and then open query analyzer...

Viewing 4 posts - 1 through 4 (of 4 total)