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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-02-14 : 13:21:34
|
| Hello friends!!I want to know how to determine exact value of total sql server memory and average memory used in MB by using QA...please explain with jargon....T.I.APapillon |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-14 : 13:31:16
|
| You can get the SQL Server counters via Query Analyzer by using sysperfinfo table in master database. I prefer to use Performance Monitor though as I typically need other counters as well.Tara Kizeraka tduggan |
 |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-02-14 : 14:45:40
|
| hi..can u pls explain the jargon in Performance monitorT.I.AShashank |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-14 : 14:56:52
|
| What do you mean by jargon? Have you used Performance Monitor before? Do you know where it is located? I'd suggest purchasing a Windows Performance Tuning book if you plan on doing any server performance tuning as it can get quite complex.This is a very good SQL Server performance site:www.sql-server-performance.comTara Kizeraka tduggan |
|
|
|
|
|
|
Total n Avg. Memory of server????