April 7, 2011 at 10:41 pm
We have some serious issues related to sql server responding very slow due to high usage of page file on the production environment.
We have 32 GB of RAM and the drives are on SAN environment.
The page file usage is around 31.7 GB.
SQL Server contains the MOSS databases(Sharepoint), there are around 48 databases of sharepoint.
Please could someone guide me so as to how performance can be improved significantly..
SQL Server version is SQL Server 2008 R2.
With Thanks,
Satnam
April 8, 2011 at 6:10 am
No short answers here. Are you sure it's memory that's the issue. Have you looked at wait states on the server? What are things waiting on? Have you gathered metrics on your long running or frequently called queries using a server side trace? You have to gather information and work from a position of knowledge.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply