I believe we are reaching some limitations with SQL Server and I have been monitoring certain items in the Performance Monitor such as: pages/sec; Bytes received/sec; Bytes sent/sec; % disk read time; % disk write time; % processor time; Log growths; percent log used; and transactions/sec. I notice quite a few spikes in Bytes sent/sec and when the % disk read time spikes for more than a few seconds, users notice a delay.
My thoughts are that 1: We need more memory on our SQL Server box (we currently have 768 meg, need a faster SQL Server box and need to distribute the load of some databases to another SQL Server; and 2: We also have a bottleneck when users are connecting via Citrix to SQL Server via our Terminal2 server (which has been tracked down to simply a slow Terminal2 box with a slow nic card - This has been confirmed that our Terminal2 is definately taking a toll and will time-out when large queries are executed.)
We also have been monitoring each of the server boxes. Are there any other recommendations for SQL Server Performance monitor that anyone could see which would be good to monitor (there are several things which can be selected to monitor?)
We've also noticed that bound MSAccess forms seem to play a significant role in the long spikes for Bytes sent/sec. I'm assuming this might be normal for bound forms and the slow SQL Server box with limited memory. Unbound MSAccess forms do not seem to present any problem and show as quick spikes for the Performance monitor.
Another problem is that I also can't seem to tie back the Performance monitor spikes with specific transactions in the SQL Profiler. Is there any way to pinpoint a spike in the Performance monitor with a specific transaction other than trying to catch the spike and quickly switching to SQL Profiler?
We are planning on upgrading our SQL Server box and also adding in another SQL Server box to help distribute the load with certain databases. We are also getting a faster box for our Terminal2 (citrix) server as these slow-downs/time-outs do not happen internally or when we use Remote Desktop Connection to connect externally (only when we connect externally via Terminal2).
Any help would be greatly appreciated! Thank you in advance.
We are in plan to build a Monitoring tool using PowerShell and Performance Monitor which could monitor 10 to 20 servers. Do you have any reference of any existing tool using Performance Monitor to monitor the SQL Server and available for free? I didn't want to put some effort, if something is available already.
I do all my monitoring locally for disk space, locks, blocking, I've 10 production servers, We need to centralised the monitoring server so from one server all the monitors can be done. Does anyone has any ideas how memory, cpus consumption, disk space, all alerts, locks, blocking, log space and job completition monitoring can be handled.
Folks! Is it possible to monitor several SQL servers in one window and notify operator about error messages. May be some new software can make it possible? Thank you.
Iam new to Sql server 2000 administration , would need inputs on counters to monitor so that I can do regular health check up of the system.
Environment:
Sql server 2000 SP3 windows 2003 sp1 2GB RAM 2GHZ processor Total size of 23 databases = 7.38GB
Counters currently montioring using the task manager on sqlserv.exe :
1. Mem Usage I assuume amount of RAM is consuming 2. VM size is virtual memory in play 3. Page Pool - Not sure what this is ? assuming paging mechnaism in windows 4. NP pool - Not sure on this 5. I/O reads - reads like select to db 6. I/0 writes - insert and update to DB 7. Page File usage - Not sure on this too, please explain
Any other counters or freeware tools to use please suggest and also please explain the above counters 3,4,7 in detail please or point me to links if possible.
I am currently evaluating Quest (Foglight & Spotlight) vs. BMC (Patrol& DBXray) and I am soliciting feedback from the community on these twoproducts or any others that I should check out. Any success stories,shortcomings or anything else that you may be able to contribute to myProof of Concept? Your insight would be greatly appreciated.RS
My manager has asked me to find a way to monitor the 'up' time of SQL Server. If possible, he would like to be able to do this automatically. Is there a way to monitor when SQL Server is started and when it is stopped? I know that I could look in the error logs, but I would like to do this automatically.
I want to know if there are any tools that will allow a DBA to monitor changes that occur on SQL databases (deletion, addittion or modifications) on any objects, and Sql security.
I have looked at Profiler in SQL and it is very limited and plus it is huge memory hog and causes degradation on your servers.
I am trying to monitor a SQL Server in a domain we have a trust in. When I add the computer to monitor I get the choice of monitoring NT objects (Processor, memory, etc) ,but none of the SQL Objects show up. Any ideas. We are using a domain admin account to try this.
We've got about fifty MSSQL Servers (7.0 and 2000) in our shop. Can anybody recommend a good tool to monitor all kind of activities and conditions on those servers?
Hi,I am new to SQL Server Administraion, and straight away thereoccured a case in which some users modified the database and I have totrack 'em out something this :-A table was modified on 17 - 03 -2006 and now I want to see whatqueries occured on that day how can I do that! I have seen thetransaction log but it ain't helpful. Do help me out!
is there a tool / feature of sql server 2005 that allows me to see all objects in memory, locks, users logged in at present and anything else i might need to monitor for things like deadlocks or resource intensive sprocs??
Hi, I'm looking for tool that will help me to monitor and analyze SQL server performance including SQL activities and server activities(cpu, memory usage) as well. I appriciate any feedback,
Our shop is expanding use of SQL Server, both 2000 and 2005. We haveLitespeed on some boxes to handle the backup/recovery jobs. Can I askwhat are considered the best tools for monitoring SQL Server, in termsof things like performance monitoring, tuning and auditing if it ispossible to get all of this functionality in one?What do you use and like?Thanks in advance.Gerry
hi guyz i want to integrate Sql Server 2000 with Microsoft Monitoring tool , and wht I exactly want is , I need a report of each users and their internet history. i have an application on asp.net 1.1 in which i need to import data from some source it may be microsoft proxy server or any monitoring tool. 1 of my mate suggested me to use the tool which lies at : Control Panel -> Ad Remove programs -> Ad Remove windows components -> managment and monitoring tool -> Monitoring he was not sure either this tool can be integrate with sql server or not. but i need some data in to my tables, can any1 help me in this regard kindly ask me if there is any confusion u guyz can email me as well ..... do let me know if know 1 find any solution thnx
SQL Stripes is an application that helps you, the SQL Server DBA, having complete control over your various SQL servers. From the high-level of monitoring essential components - to the low-level of analyzing your various databases, tables etc… This is *not* another Query-Analyzer like tool, nor does it intend to be. The idea is that each one of your servers gets a 'Stripe' which contains valuable real-time data on the selected server. SQL Stripes is an intuitive and easy to use application, which is intended to make your DBA life a bit easier.
SQL Stripes is completely free. Please send your feedback/questions/suggestions
We currently use Zabbix to monitor our SQL Servers, generally we use Perf_Counters to gather performance information (CPU Usage, Memory, Blocked process etc.), Zabbix also lets us monitor services as to whether they are up or down. I have searched google looking for any information regarding the monitoring of AlwaysOn/Mirroring within Zabbix and to date ave found nothing. What I am looking to alert on is an indication that Mirroring has stopped/ been interrupted with say something like "Not Synchronized"... Zabbix and monitoring SQL Server 2012 and specifically monitoring AlwaysOn...
Does anyone have any basic, simple scripts of sp's that I can give mycomputer operators to use to monitor for serious conditions on our sqlservers? We are new in the ms-sql arena, a small shop and we cantreally purchase any tools to monitor these servers, but we need somebasic checks that we can use to make sure a server is performing in areasonable fashion, no blocks, cpu<xx%, memory not pegged, IO working,etc...and we need to be able to do this without bugging ourprogrammers every time we are wondering why things are slowwnig down.We are a split shop between as400s and sql servers, and our operationsstaff has no problem performing this type of duty on the 400s. I thinksince the sql servers are so easy to deploy into production, the ideaof how to monitor these things health got lost in the shuffle andallowing the programmers to do it just serves to destabilize ourenvironment.Please help! Our shop has turned to chaos since we went live withMSSQL centric applications and everytime one programmer "resolves anissue" some other programmers application starts to act up.
I understand the rule of thumb that the CPU should not be over 90%. If you take the four counters (%processor time,%privileged time, %user time, %interrupt time, and interrupt seconds), what combination gives you your CPU time ?
I have been asked to monitor SQL to tell me when we are performingbetter than others. Can anyone tell me what kinds of scheduled jobs orscripts they utilize?
Hi ,Is there a way/tool in Sql Server 2000 SP3 tomonitor all activities going on in the Database ?For example, I first create an empty database.Then I have an ERWIN generated DDL to createall views and tables. After that, I have INSERTscripts that populate all the base tables. What Iwant to monitor is success or failure for eachscript.Thanks,N.
Hi, I have implemented health monitoring for my web-site, using the SQL provider. Health monitoring works fine when the website is run from VS2005, using the built in web server, all the expected events are inserted into the aspnet database. However when I deploy the site onto IIS, no events are ever inserted into the database. I would appreciate some help figuring out why this is happening! The code that implements the health monitoring in my web.config file is:1 <healthMonitoring 2 enabled="true" 3 heartbeatInterval="0"> 4 <bufferModes> 5 6 <remove name="Analysis"/> 7 8 <add name="Analysis" 9 maxBufferSize="10" 10 maxFlushSize="2" 11 urgentFlushThreshold="2" 12 regularFlushInterval="00:00:02" 13 urgentFlushInterval="00:00:01" 14 maxBufferThreads="1"/> 15 16 </bufferModes> 17 18 <providers> 19 20 <remove name ="SqlWebEventProvider"/> 21 22 <add name="SqlWebEventProvider" type="System.Web.Management.SqlWebEventProvider, 23 System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" 24 25 connectionStringName="SQL_ASPNET" 26 maxEventDetailsLength="1073741823" 27 buffer="true" 28 bufferMode="Analysis" 29 30 /> 31 32 </providers> 33 34 <eventMappings> 35 36 <remove name ="All Events"/> 37 <add name="All Events" 38 type="System.Web.Management.WebBaseEvent, System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a"/> 39 40 </eventMappings> 41 42 <profiles> 43 44 <remove name="Default"/> 45 <add name="Default" 46 minInstances="1" 47 maxLimit="Infinite" 48 minInterval="00:10:00" 49 /> 50 </profiles> 51 52 <rules> 53 54 <add name="All Events" 55 eventName="All Events" 56 provider="SqlWebEventProvider" 57 profile="Default" 58 minInterval="00:00:01" 59 minInstances="1" /> 60 61 </rules> 62 63 </healthMonitoring> 64
Can anyone show me in SQL7 how to obtain Available Space on a particular filegroup in a database (not the database or datafile). I am trying to include this in a script to monitor my database which uses Filegroups and I have every other info that I need (from the sysfiles table) except the available space. Thanks in advance!
In Sql 7 What is the easiest way to monitor the number of connections? I have been asked to create a report that monitors the number of logins every hour.
I am new to sql server and sould like to know how I can monitor the server performance on sql servers 6.5 and 7. In sybase we can run sp_sysmon. Is there anything similar to this for sql server.
Can anybody help me with the following on my MS SQL Server 2000 database.
1. All tables should have a lastModificationDate column. Any changes and inserts should have the system time updated with a trigger or so. We shouldn’t be inserting the value using SQL statements into this column.
2. There shouldn’t be any deletes on the table. Any deleted records should be marked as inactive or deleted, so it won’t come in queries, but should be physically present in the tables.
3. A modification log table, which will carry the table name, the column identifier, user modified, old value and the timestamp.
I would just like to know what everyone uses to monitor SQL usage? We have a SQL 2000 server that already has several applications sharing it and everyone wants to keep forcing more onto it.
I want to be able to judge when this server has reached it's capacity or how much more it can allow. Can SQL profiler alone do this for me?
