CompTIA
Exam Vouchers
Save money on CompTIA exams
| Question of the day
Sign up to receive
interactive practice questions
for MCSE, CompTIA
Cisco and other exams
| TestKing
Get MCSE, MCSD, CCNA, CCNP,A+, N+ and many more | * ExamSheets *
Guide for Success!
Actual Questions & Answers
MCSE, MCSD, A+ ,CCNA, CCNP
Oracle 8i, Oracle 9i Online practice tests
Certification sites Online university Online college Online education Distance learning Software forum Server administration forum Programming resources
|
|  |
| Author |
what's the best way to monitor memory usage
|
jdenwigr
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
 what's the best way to monitor memory usage
I'm using task manager to monitor the memory usage by sql
server but don't think it's the right tool.
Could someone tell me what's the best way or which tool is
the best to use?
I'm suspecting that sql server doesn't release memory
dynamically as it should.
Thanks so much.
jd
Report this post to a moderator
|
|
 06-27-02 09:25 PM
|
|
Andrew J. Kelly
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: what's the best way to monitor memory usage
You can use performance monitor to view several memory counters. SQL Server
will only release memory if the OS specifically calls for it. Once the OS
is done with it SQL Server may very well immediately grab it right back.
This may happen too fast for you to see with either of these tools. This is
normal and by design.
--
Andrew J. Kelly, SQL Server MVP
TargitInteractive
"jdenwigr" <jdenwigr@hotmail.com> wrote in message
news:113d601c21e28$2299b8e0$a4
e62ecf@tkmsftngxa06...
> I'm using task manager to monitor the memory usage by sql
> server but don't think it's the right tool.
> Could someone tell me what's the best way or which tool is
> the best to use?
>
> I'm suspecting that sql server doesn't release memory
> dynamically as it should.
>
> Thanks so much.
> jd
Report this post to a moderator
|
|
|
06-28-02 12:25 AM
|
|
|
Featured site: MCSE, MCSD, CompTIA, CCNA training videos
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is OFF. |
|
ExamNotes forum archive
|
