Search Results | SQL Server Performance Forums

multi instance sql server 2012

Thread by: timscronin, Jun 5, 2013, 2 replies, in forum: ALL SQL SERVER QUESTIONS

I have a big box with sql 2012 standard edition. 128 gig of ram. Since there is a 64 gig memory limit on 2012 std edition, I was thinking of firing...

sql 2012 standard edition memory limits

Thread by: timscronin, Jun 4, 2013, 2 replies, in forum: ALL SQL SERVER QUESTIONS

My bad it looks like sql 2012 standard edition only can use 64 gig of memory (change from 2008) 2 ?, I have seen some people post this is not true,...

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

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...