| Author |
Topic |
|
WS593
Starting Member
6 Posts |
 Posted - 2008-12-18 : 13:35:06
|
| Hi, Windows 2003 SP1, SQL 2005 SP2 Standard edition, 16 processors, 32 GB ram (SQL set at min 10GB max 26GB. Around lunch time, we have a severe app performance degradation for about 10 minutes. Using Idera DM, all we see in red is paging. We cruise around 300 pages/sec. We can't find the roor cause. I don't understand why we even have paging going on with so much memory allocated.Any advise wouldl be greatly appreciated. Thank you. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
WS593
Starting Member
6 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
WS593
Starting Member
6 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
WS593
Starting Member
6 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-18 : 22:07:35
|
| I guess you can't set 'lock pages in memory' in standard edition or it doesn' t have any effect at all. |
 |
|
|
WS593
Starting Member
6 Posts |
Posted - 2008-12-19 : 10:05:03
|
I think sodeep is right. It is set but I read somewhere that it is only for enterprise edition. I heard that upgrading to enterprise edition would be very expensive because the box has 16 processors. Is that true? Thank you all for your input.quote:
Originally posted by sodeep
I guess you can't set 'lock pages in memory' in standard edition or it doesn' t have any effect at all.
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-19 : 11:33:07
|
quote:
Originally posted by WS593
I think sodeep is right. It is set but I read somewhere that it is only for enterprise edition. I heard that upgrading to enterprise edition would be very expensive because the box has 16 processors. Is that true? Thank you all for your input.quote:
Originally posted by sodeep
I guess you can't set 'lock pages in memory' in standard edition or it doesn' t have any effect at all.
It doesn' t advantages of it in STD Edition? |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-12-19 : 11:47:48
|
| You need to determine if paging is really the problem. Paging does not always mean that data is being moved from memory to the page file or from the page file to memory.There are many kinds of paging that will not cause any problem. For example, when you run backups, you will see paging as the OS allocates pages for the file system cache.CODO ERGO SUM |
|
|
|
WS593
Starting Member
6 Posts |
Posted - 2008-12-19 : 13:28:27
|
Point well taken. Thank you all for your help. BTW This is the best SQL forum out there.quote:
Originally posted by Michael Valentine Jones
You need to determine if paging is really the problem. Paging does not always mean that data is being moved from memory to the page file or from the page file to memory.There are many kinds of paging that will not cause any problem. For example, when you run backups, you will see paging as the OS allocates pages for the file system cache.CODO ERGO SUM
|
|
|
|
|
Paging in 300 pages/sec and perf degradation