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 |
|
hoemee
Starting Member
2 Posts |
 Posted - 2011-01-30 : 22:43:16
|
| Hello - I am new to this forum and new to SQL 2005 admin and troubleshooting.....need help witht this persistent error message locking up our new server. We are running Server 2003 RS, 32 bit with 4 GB ram. We keep getting this message that states our sql process memory is paged out and it locks up the server to all users frequently......help! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-31 : 07:04:27
|
| Is anything other than SQL Server running on the box?Is Lock Pages in Memory granted for the service account?What is the max memory set to? |
 |
|
|
hoemee
Starting Member
2 Posts |
Posted - 2011-01-31 : 10:01:19
|
| This is a brand new Dell T710....it is a file and print box also running terminal services. We are running SQL 2005 for mediacl software and also SQL 2005 Express running Kaspersky and Backup Exec 2010 R2. We have enabled AWE and the mem settings are 1024 and 2048...the lock pages in memory is grayed out...... |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-31 : 14:07:31
|
| Well, I'd have a look at what apps are consuming how much memory.When you have several applications running on the same box, memory contention issues are not uncommon. |
|
|
|
|
|
|
Error Event ID 17890