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 |
|
trantuangtvt
Starting Member
1 Post |
 Posted - 2011-03-16 : 04:26:00
|
| Hi all,I have a server memory issue after replicating database!I have 2 servers.Server1:- Windows 2008 standard 64bit- MS SQL 2008 standard 64bit- Role: Publishion and Distribution- Kind of replication: snapshot- Push data to subcriptionServer 2:- Win 2003 Standard 32 bit- MS SQL 2000 Standard 32 bit- Role: subcriptionMy database replication proccess is ok but after finishing replication proccess, SQL 2008 has still captured a lot of memory (7GB) while it only captured about 2GB beforeIn case I restart MS sql 2008 service. it will come back as normal (2GB)...!Do you know why sql 2008 keeps to much memory? how does it release RAM automatically after the replication process finshed?Sorry my bad EnglishThanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-03-16 : 13:14:16
|
| This is normal. Although SQL 2008 manages memory better than previous editions, you'll often find that it won't release the memory unless another process is requesting it. Is it a dedicated database server? If so, then what you described is normal. If it's not dedicated, then SQL won't release it until another app needs it and likely no other apps needed it based upon your information.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
DB replication from sql2008 64bit to SQL2000 32bit