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 |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2009-07-31 : 21:46:36
|
| folksI have a sql 2005 enterprise edition 32 bit on a windows server 2003 sp2. Suddenly since the last week, everytime we run the re-indexing job, the memory is completely chewed up and never released. To the point that the server crashes. We cannot get to it using remote desktop or VMWare tools.the other two important processes use the same memory. not sure if any of you have encountered such a problem.At this point, we have no option but to reboot the server.Any ideas help will be appreciated.CheersParesh MotiwalaBostonRegardsParesh MotiwalaBoston, USA |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-31 : 21:53:46
|
| so sql is running on VMWare?how much memory is allocated to the VM hosting SQL Server? What is max memory setting on SQL Server?What do you mean by 2 other processes? What are they?Also disable VMs ability to reorganize OS files |
 |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2009-08-01 : 16:44:22
|
| there is 4GB allocated to the VM.currently i have provided 2.5GB to the SQL Server.It used to be 3.5 GB for SQL server, but the server has two other services, W3P and another propreitory service.They also tend to take a bit of memory.I will talk to the System Admins about, disabling VM's ability to reorganize OS Files.Thanks for the help.RegardsParesh MotiwalaBoston, USA |
|
|
|
|
|
|
Sudden issue with reindexing job