Armenian Knowledge Base  

Go Back   Armenian Knowledge Base > Technical sections > Languages, Compilers, Interpreters
Register

Reply
 
LinkBack Thread Tools
Old 12.01.2005, 08:24   #1
Младенец
 
Join Date: 01 2005
Location: Armenia
Age: 39
Posts: 5
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Unhappy MS SQL RAM problem

Всем привет
у меня стоит MS SQL 8.0 (2000)
и постоянно забивается ОЗУ
процес sqlservr.exe постоянно растет
и приходится время от времени перезагружать SQL
чтобы освободить ОЗУ

есть идеи?
Reply With Quote
Old 12.01.2005, 09:00   #2
★★★★★★★★★★★★★
 
Hrach_Techie's Avatar
 
Join Date: 08 2004
Location: London, UK
Age: 38
Posts: 16,531
Downloads: 8
Uploads: 0
Reputation: 482 | 6
Default

page file size-i het xaxacel es?
Reply With Quote
Old 12.01.2005, 09:40   #3
Младенец
 
Join Date: 01 2005
Location: Armenia
Age: 39
Posts: 5
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

Проблема не в page -e
постепенно обьем памяти растет
и под конец достигнув около 800Мб программы дают connetion timeout
исправляется только перезапуском SQl -a
Reply With Quote
Old 12.01.2005, 10:13   #4
Guru Apprentice
 
Join Date: 02 2002
Location: /dev/null
Age: 41
Posts: 524
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

Выкинь нах. MS MSQ и поставь MySQL, у него насколько я знаю память не "протекает". То что ты описываешь - классический memory leak.
Reply With Quote
Old 12.01.2005, 10:16   #5
Guru Apprentice
 
Join Date: 02 2002
Location: /dev/null
Age: 41
Posts: 524
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default I stay corrected

Google нашел следующее (линк здесь

INF: SQL Server Memory Usage
Article ID : 321363
Last Review : October 30, 2003
Revision : 1.0
This article was previously published under Q321363
On this Page
SUMMARY SUMMARY
MORE INFORMATION MORE INFORMATION
SUMMARY
When you start SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. Additionally, the Task Manager and Performance Monitor may show that the physical memory available on the computer is steadily decreasing until the available memory is between 4 to 10 MB.

This behavior alone does not indicate a memory leak. This behavior is normal and is an intended behavior of the SQL Server buffer pool.

By default, SQL Server dynamically grows and shrinks the size of its buffer pool (cache) depending on the physical memory load reported by the operating system. As long as enough memory is available to prevent paging (between 4 - 10 MB), the SQL Server buffer pool will continue to grow. As other processes on the same computer as SQL Server allocate memory, the SQL Server buffer manager will release memory as needed. SQL Server can free and acquire several megabytes of memory each second, allowing it to quickly adjust to memory allocation changes.
MORE INFORMATION
You can establish upper and lower limits to the amount of memory (buffer pool) used by the SQL Server database engine with the min server memory and max server memory configuration options. Before you set the min server memory and max server memory options, review the references in the section titled "Memory" in the following Microsoft Knowledge Base article:
319942 HOW TO: Determine Proper SQL Server Configuration Settings
Note that the max server memory option only limits the size of the SQL Server buffer pool. The max server memory option does not limit a remaining unreserved memory area that SQL Server leaves for allocations of other components such as extended stored procedures, COM objects, non-shared DLLs, EXEs, and MAPI components. Because of the preceding allocations, it is normal for the SQL Server private bytes to exceed the max server memory configuration. For additional information about allocations from this unreserved memory area, click the article number below to view the article in the Microsoft Knowledge Base:
316749 PRB: There May Not Be Enough Virtual Memory with Large Number of Databases
REFERENCES
SQL Server Books Online; topics: "Effects of min and max server memory"; "Memory Architecture"; "Memory Architecture"; "Server Memory Options"; "SQL Server Memory Pool"
APPLIES TO
• Microsoft SQL Server 2000 Standard Edition
• Microsoft SQL Server 7.0 Standard Edition
Top of Page Top of Page
Keywords:
kbinfo KB321363
__________________
\/\/h47'5 1n 4 n4m3? 7h47 wh1(h w3 (4|| 4 r053,
8y 4ny 07h3r n4m3 w0u|d 5m3|| 45 5w337...
Reply With Quote
Old 12.01.2005, 10:17   #6
Младенец
 
Join Date: 01 2005
Location: Armenia
Age: 39
Posts: 5
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

Считаю что надо понять проблему а не бежать от нее
может ошибка не в SQL a .NET
тоесть проблема в проге которая работает с SQL
Кстати софт на писан на C#
Reply With Quote
Old 12.01.2005, 11:19   #7
Профессор
 
Nikita's Avatar
 
Join Date: 01 2005
Location: Perm
Age: 38
Posts: 2,142
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

v linux-e yest` komanda "sync" mojet i v winde chtoto podobnoye yest
a yesh`o mojet u tebya Buffer ochen` bol`shoy stoit ... i yego nujno umen`****`
Reply With Quote
Sponsored Links
Reply

Thread Tools


На правах рекламы:
реклама

All times are GMT. The time now is 14:36.


Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.