January 16, 2009 at 12:07 pm
Hi Folks,
I am getting a lot of spikes on Page/sec, it is averaging from 25-50? but the my % Disk time is really low around .5,which tells me that 20-50 may not be that bad. This on a 64bit 2005 sql, and 64bit OS and a SANl.
My guess is the SAN is keeping up fine, but I would like to reduce the spikes as much as possible.
The paging appears to be from my full text search after looking at a profiler trace.
The task manager is showing a high number of page faults 1,143,506,140 for full text engine.
Right now the SQL memory setting are on default, I planned on backing of the max setting by about 4 gig, which is the size of the DB the full text search is hitting. I do have the Full text search DB on it own spindle and the log as its own spindle as well.
Will backing off the sql memory reduce paging? my page file usage is averaging about 2%.
Thanks a Bunch
January 20, 2009 at 3:46 am
are we talking about page file usage here?
If so then if you have a page file it will get used no matter how much available memory there is. I find this an extremely annoying aspect of windows, for example I was building a new x64 server with 64gb of ram. With sql server 2005 installed and only allocated 8gb of ram so a good 50GB+ available memory there was still constant paging on the server - my view - this is cr*p!!
With adequate memory on a dedicated x64 server I'd not have a page file - if you search the internet you'll find many many posts concerning using xp with 4gb of ram and removing the page file to get better performance. I've run x64 SSRS servers without a page file for a long time without any issues ( other than some monitoring software which struggles with no page file!! )
Sadly you will always have paging.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 21, 2009 at 9:44 am
25-50 pages/sec isn't bad. As long as avg disk sec/read and avg disk sec/write aren't troublesome your IO is probably doing OK.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 23, 2009 at 12:00 pm
Thanks guys....good to know I was in the right direction!
January 23, 2009 at 12:11 pm
You really need to look at the type of paging. There are many types of paging that have nothing to do with the page file. They can just be allocations of new pages to a process.
Also, you should be aware that backups and transaction log backups cause paging as the OS allocates pages to the file system buffer.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply