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 |
|
pap
Starting Member
13 Posts |
 Posted - 2004-03-09 : 03:02:52
|
| Hello,Can you please help me with this:The server where the SQL Server is installed is getting without resources because the SQL is consuming all the resources of the machine. I heard that there is something in the SQL Server where we can limit the range (resources) of action of the SQL, this way the server wont be stacked. How can I do this ?Thank youPaulo |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2004-03-09 : 04:51:38
|
| I think you are speaking about memory.From BOL:Microsoft SQL Server 2K dynamically acquires and frees memory as needed. It is typically not necessary for an administrator to specify how much memory should be allocated to SQL Server, although the option still exists and is required in some environments.To set a fixed amount of memory:Expand a server group.Right-click a server, and then click Properties.Click the Memory tab.Click Use a fixed memory size (MB), and then position the fixed memory slider.HTHFranco |
 |
|
|
pap
Starting Member
13 Posts |
Posted - 2004-03-09 : 05:02:19
|
| First of all thank you for your help.Can you tell me if this will increase the communications ??? Because when the computer is stacked, all the clients can't reach the server.Once again, thank you for your help |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-09 : 08:49:25
|
| You need to monitor your memory. There are also several other things to consider though.What version of Windows/SQL Server are you using, and what service packs do you have on?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Resources