如何监视SQL Server 2005中的应用程序 [英] How to monitor applications in sql server 2005

问题描述

我有 SQL SERVER 2005 ，它具有一系列应用程序

这些应用程序之一导致大量RAM的消耗，因此最多使用 15.9 GB RAM

我需要知道如何监视服务器的工作以减少此问题.控件中需要监视的必需是什么，因此我可以专注于它们

I have SQL SERVER 2005 and it has a range of applications

One of these applications is causing the consumption of a large amount of RAM so that uses up to 15.9 GB RAM

I Need know how to monitor the work of the server to reduce this problem. What are the necessary things to watch in the control so I can concentrate on them

推荐答案

^ ]可以拍摄内存使用情况的快照.

您可以通过配置选项限制Sql Server使用的内存量. [分析执行计划 [ ^ ]，看是否可以改进它"的性能.

DBCC MEMORYSTATUS[^] can take snapshots of memory usage.

You can limit the amount of memory Sql Server uses with configuration options.[^].

If you find that a particular procedure is causing the usage you can analyze the execution plan[^] to see if you can improve it''s performance.

使用MS的perfmon(性能监视器)检查SQL Server计数器

http: //blogs.technet.com/b/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx [ http://searchsqlserver.techtarget.com/SQL-Server-PerfMon-counters- for-tracking-Windows内存 [ ^ ]

Check the SQL Server counters with the perfmon (Performnace monitor) of MS

http://blogs.technet.com/b/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx[^]

http://searchsqlserver.techtarget.com/SQL-Server-PerfMon-counters-for-tracking-Windows-memory[^]

这篇关于如何监视SQL Server 2005中的应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！