回複：不客氣。談SQL耗內存問題

來源: peterpang 於 2003-11-26 10:14:00 [] [舊帖] [給我悄悄話] 閱讀數 : (918 bytes)
本文內容已被 [ peterpang ] 在 2004-02-06 15:24:48 編輯過。如有問題，請報告版主或論壇管理刪除.
回答: Thanks DBDB 由 peterpang 於 2003-11-26 05:34:00

after I rebooted the server, the memory for sql server lower to 12MB, and stay that level for all day toaday.
I see the property of the sql server, it show me pathed SP3, but my boss said we nerver applied service pack 3.
I did a lot search on google and microsoft, some people said, sql server dynamic memory configuration work just like that way, it never release it until OS or other process request it.
some people said , there could be a memory leak.
I used to have a teacher when I was a student, he said that sql server must be reboot every 45 days.
And I read book "sql server 2000 for experienced DBA" author is Brian Knight,he said if 2G memory for didecated sql server for any production database, sql server procesee could use up to 1.7 GB, which is ok.
It is too much information in my mind now, I just want to get organized.
Thank you again DBDB for answer my questions.
Peter




--文學城www.wenxuecity.com--

所有跟帖： 

• 談SQL耗內存問題 -peterpang- ♀ 給 peterpang 發送悄悄話 (287 bytes) () 11/26/2003 postreply 10:49:00

請您先登陸，再發跟帖！