p.s. NOT limiting by TOP N wouldnt cause the 10+ minute processing time... so if the followin was used select * from ....... it had no issues... it...
over the weekend i was able to resolve the issue... it came down to a nested select top 1 ........ query that had no purpose there... AND it had a...
ALTER Procedure [dbo].[SomeProc] @p_StopHour INT = 0 -- 0-23 ,@p_StopMinute INT = 0 -- 0-59 AS SET NOCOUNT ON DECLARE...
using perfmon., when the spike in processor appears., the recompile pretty much stays at 0... so recompile is not the problem., i think there is a...
which event do i need to look at to figure out the recompile counters? i setup the events specified in fig 3 on...
9.00.4035.00 SP3 Standard Edition tried job again., still using 100% cpu..
9.00.1399.06 RTM Standard Edition thats odd... i was pretty sure the IT admin installed the SP's ReleaseSqlservr.exe RTM2005.90.1399 SQL Server...
compatibility has not been changed to 90... there are probably a decent # of tsql statements that might break in 90 that work in 80... this DB...
A legacy 2000 DB server was migrated to 2005.This was not "upgraded" the box was re-imaged, sql 2005 installed with 2 instances, and the databases...
Separate names with a comma.
