Search Results | SQL Server Performance Forums

proc cache dive

Thread by: timscronin, Dec 20, 2011, 3 replies, in forum: ALL SQL SERVER QUESTIONS

I had a 3rd party app have page life and proc cache, both take a dive yesterday, at the same time work tables went through the roof. At home sick...

table partition

Thread by: timscronin, May 12, 2009, 1 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

I have a 3rd party app with several tables which are 7-14 million rows. Presently i have the data on a RAID 10, log files on a RAID 10, tempdb on...

Best place for tempdb

Thread by: timscronin, Mar 13, 2009, 3 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

I have a sql 2005 install on a active/passive cluster attached to a SAN. Currrently I have an array set for my mdf E:, my indexes i:, translogs k:,...

Objects in procedure cache

Thread by: timscronin, Mar 10, 2009, 1 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

I had a sql 2005 box choke yesterday, buffer cache was fine but proc cache went from 90 to 45. I had rebuilt stats over weekend for all db's Since...

64 bit install

Thread by: timscronin, Dec 5, 2007, 1 replies, in forum: SQL Server 2005 General DBA Questions

I am going to be doing my first install of sql server 2000 and 2005 on a 64 bit machine (2 virtual servers) on a new box. Anything special about...

high buffer cache but low cache hit

Post by: timscronin, Sep 18, 2003 in forum: Performance Tuning for DBAs

This is a pharmacy application used for data entry (20-30) users running a VB6 app against it. I thought there was a way to view what were the top...

high buffer cache but low cache hit

Thread by: timscronin, Sep 18, 2003, 5 replies, in forum: Performance Tuning for DBAs

I have a SQL 2000 server running advanced server on a new quad processor box with 8 gig of RAM using AWE. My system queue is always less than .2, and...