I am running SQL Server 2005 SP1. I have a linked server connection between 2 servers with replication set up. When I run the following, data is...
Thanks Joe. I will attempt to clarify. The Buffer Cache Hit ratio of 99% was during the High CPU episode. I did not have a Pages/Sec counter...
The procedure does utilize temporary tables. Upon further analysis of Profiler, taken during the high CPU episode, it was not recompiles occurring,...
We have 18 servers, all running Windows 2003 R2, with SQL Server 2005 SP1. We have approximately 40 databases per server (give or take, plus or...
I have used Profiler, which led to this thread. I am seeing Full Compiles and Recompiles on several of our most frequently called procedures. One in...
Can high CPU due to high recompiles feed off itself, meaning, the connections and activity on our server increases: 1. Which causes a higher number...
We have about 200 databases on approximately 20 servers and possibly doubling in the near future. These databases have identical schemas. We are...
So if I have: 5 rows that have an LSN = 5065000008293000544, all with a status of 2 (and are the last 5 rows returned by DBCC LogInfo) and 5 rows...
Considering the output of DBCC LogInfo(TempDb) that was in my initial post on this thread, does that mean that my "Active Log" consists of all the...
Thanks Satya. We are getting somewhere but I am still not clear. Consider the output of DBCC LogInfo(TempDb) that was in my initial post on this...
What is the definition of active? quote:Originally posted by MohammedU It means Virtual log file is active...
So, if I run DBCC LOGINFO(TempDB) and return the following, is that telling me all the Status 2 rows are waiting to be written to TempDB, have been...
We have a number of complex queries in stored procedures that sometimes run well (under 5 seconds), but other times take several minutes (with an...
While I appreciate the info, I am still not getting question #3 addressed, unless you are in a round about way saying definitively that the object_id...
I was wondering...I have a select statement that inserts into a Temporary Table. From my understanding, the select statement should not be locking...
OK. I have answered #1 and #2 on my own, but am still seeking an answer on #3. Any help in answering #3 would be appreciated.<br /><br />#1<br />DBCC...
Sorry Satya, but I feel a bit insulted. I have already been to that link, and that link does not even begin to address the three questions I...
I have a blocking issue, running SQL 2000, SP4, on Windows 2003.<br /><br />The SPID at the head of the blocking chain = 226. SPID 226 has the...
Unfortunately I cannot post the results. Too much proprietary info, and with 16 joins I do not want to rename items to protect the schema naming and...
Yes, the temporary table is created at the very beginning of the procedure and is entirely populated before it is used by the SQL Statement....
Separate names with a comma.
