Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2011-09-16 : 11:28:56
|
| Most of the time there is no paging on our database server but some days it jumps to 2000 pages/sec and stays there for hours. Whenever this happens I check the server and for memory it says...Available 7000Free 0It seems that the paging happens whenever the "Free" value is 0. I have 64 gigs of RAM installed. I've allocated 45 gigs of it to SQL Server. If I look at the processes I don't see any other processes chewing up large amounts of memory. The disk queue length is very low so maybe it is nothing to worry about but it seems strange. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-16 : 11:34:54
|
| This is a dedicated SQL Server?Is virus scan running?What is PLE? And Buffer Cache Hit Ratio? CPU?Are there warnings in the event logs? |
 |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2011-09-16 : 12:10:49
|
| Thanks for the reply.Buffer cache hit ratio is consistently at 99%. CPU averages 15%. Sophos real time scan is running but I don't see anything in terms of scans that would explain the paging. It is a dedicated SQL box (Rackspace hosted). There are errors in the event log including...Event 140, Report Server Windows Service: Configuration errorEvent 56, TermDD: Error in protocol stream disconnected the clientEvent 10009, DistributedCOM: Was unable to communicate with the computer <<computer name>>Event 18210, MSSQLServer: Extend Disk Backup: failure on backup device |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-16 : 12:31:58
|
| If SQL Server isn't doing the paging then I won't worry too much about it as long as performance is ok.Are swap files big enough? |
|
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2011-09-16 : 16:52:44
|
quote:
Are swap files big enough?
How do I know that? Is swap file the same as paging file? It is 4 gig currently. I've read that on SQL boxes the paging file should be small unlike non-sql servers which should be 1.5 times the RAM. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-16 : 17:58:42
|
| I make 'em big. Maybe your virus scanner is paging? |
|
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2011-09-16 : 18:30:05
|
| There is a process running called CLBackup.exe that is processing 12 megs/sec. I believe that is Rackspace's backup process. That is my prime suspect at this point! |
|
|
|
3magic
Starting Member
14 Posts |
Posted - 2011-09-22 : 07:45:48
|
| Are there warnings in the event logs? |
|
|
|
aougnou
Starting Member
1 Post |
Posted - 2012-09-21 : 09:08:55
|
| @ferrethouse: Yes CLBackup.exe is part of ComVault backup that is scheduled by RackSpace to run your server backups. I had something similar happened and I found out that it was due to the automated backup jobs that were set up by rackspace. To solve it work with rackspace to figure out how your server backups are scheduled and set up and how to optimize them. |
|
|
|
|
|
|
High memory paging (pages/sec)