Let me preface this by saying I'm aware of SQL server memory architecture, i.e it takes as much as it can get it's hand's on ...I've read through all the post's on here and they have been very helpful ... However if someone could take a look at these these
configuration values ...
I'm trying to get a new server dialed in, I'm still having some user end speed issues, and application hangup's that seem sql related ... I'm by no means a dba so if someone who's knowledgeable could point me in the right direction I would appreciate it
... I feel like something is not configured properly ...
The box has Microsoft SQL Server 2008 (RTM) 64-bit on Windows NT 6.0 <X64> Service Pack 2
Dell Power Edge R10 16 Logical CPU, 8 Hyperthread 12gig of memory
(Right now SQL has 10/12 gig allocated in the task manager ( I know this is not accurate ) I'm adding another 12 gig tomorrow ... So the machine will be running 24 gig)
There's two 9 gig databases running on the machine with several 4-6 million row tables .... Server is SQL Dedicated
Page Life Expectancy
18,038 under moderate load, tho I've seen it as low as 1,200 under heavy load ....
Buffer Pool Usage
View Complete Post