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 |
|
sorrentmutie
Starting Member
12 Posts |
 Posted - 2004-12-02 : 09:10:58
|
| Dear friends,I'm testing a visual basic.net application writing into a sql server 2000 database. Every job, I write 100000 rows in a table.At the end of the first job, the sqlserver.exe process sums up to 54,58 MB of memory usage. I quit my application, start again and launch a new job: at the end of the second job sqlserver.exe sums up to 57.74 MB of memory usage.Here is a detailed table for 6 consecutive jobs:Number of Job memory usage (MB)1 54.582 57.743 61.504 65.265 69.056 72.77I am sure that every database object in my vb application is terminated.I don't think this is a normal behaviour.The only way to reduce the memory usage is to manually stop the sql server service.I would like to know if you observe such a phenomena with your application.thanks for your kind attentionSalvatore |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-02 : 10:00:11
|
| Unless you limit it sql server will grab as much memory as it thinks it can use. If you need memory for something else then either get another server or limit what sql server is allowed to use.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sorrentmutie
Starting Member
12 Posts |
Posted - 2004-12-02 : 10:10:26
|
quote:
Originally posted by nr
Unless you limit it sql server will grab as much memory as it thinks it can use. If you need memory for something else then either get another server or limit what sql server is allowed to use.
Thanks for your answer.Even if I put the database on a dedicated server, the memory usage will raise till the service is not stopped. How can I limit the limit sql server is allowed to use? I'm nont an expert...Salvatore |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2004-12-02 : 10:11:38
|
| Right click the server in Enterprise Manager and choose properies. The memory tab is what you want. |
|
|
|
sorrentmutie
Starting Member
12 Posts |
Posted - 2004-12-02 : 10:19:43
|
quote:
Originally posted by Andraax
Right click the server in Enterprise Manager and choose properies. The memory tab is what you want.
Sorry but I don't see a memory tab.Just General , data File, transaction log, filegroup, options.Data file refers to the database size, I suppose.Salvatore |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-02 : 10:22:58
|
| You have right clicked on a database name - you need to right click on the server name.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
sorrentmutie
Starting Member
12 Posts |
Posted - 2004-12-02 : 10:24:51
|
quote:
Originally posted by nr
You have right clicked on a database name - you need to right click on the server name.
OOOOPPPSS.. THANKS!Salvatore |
|
|
|
|
|
|
|
|
SQL server memory usage