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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Server Memory Consumption

Author  Topic 

learntsql

524 Posts

Posted - 2009-12-02 : 01:14:16
Hi..
I have few queries about SQL Server.
How the server memory is consumed when i open SSMS in server itself(some times).
will it get slow?
How the performance impact would be?.
What happens if both application(5) and database(5) servers run on same physical machine?
Each five applications have around 500 users.
How to analyze performance counters like
-->Page reads/Writes,CPU USEAGE,memory,etc...
for both application and database servers.
TIA.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-02 : 01:39:48
All queries use memory.

It is not recommended to have the applications run on the database server.

Use Performance Monitor to analyze the counters. Do some searching on what the reasonable ranges for each of those you are interested in.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -