MS SQL Server :: Monitoring Tools

3rd Party Monitoring Tools
I have been using the built-in tools of SQL Server (email and netsend) to monitor and alert me about some basic issues (like severity errors and job failures) with our SQL servers. We are now approaching a level and number of servers where I think we need to get a more global and more stable solution to monitoring and alerting.

So what third party tools are you are using to monitor your SQL Servers?

Thanks

SJ
shawn.johnson@kenexa.com

View Replies ! View Related

MS SQL Server Monitoring Tools
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?

View Replies ! View Related

Server Monitoring Tools
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.

View Replies ! View Related

Tracking Changes And Monitoring Tools
I want to integrate my Production SQL boxes to Visual Source safe.
Can you please guide me on this also if there is any Alternative to
track the chnages in the stored Procs?

How is SQL SPOT LIGHT from Quest as a monitoring tools?.
Or
Can you please suggest me any other tools which are good for monitoring SQL Servers.

Thx
Venu

View Replies ! View Related

Favorite Monitoring (Performance) Tools?
I'm fairly new to the DBA thing.
I've been doing quite a bit of research on monitoring MSSQL performance.

What tools are you guys using?
PerfMon, Dbartisan, Spotlight, or what?

I'd like to find some free or affordable way to watch our Servers to check health/performance/etc.

View Replies ! View Related

Performance Monitoring Tools For SQL Server
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,

Thank you,

Yelena

View Replies ! View Related

Tools For Monitoring Sql Database Access
is there a tool or vb.net code for monitoring who is accessing my sql 2005 express databases? username, computer name, etc.?

View Replies ! View Related

Sql 2005 Server Monitoring With Snmp Tools
I would like to monitor the sql 2005 servers with a snmp tool, but I read on the MSDN, that this feature is no longer supports...So what should we do?

View Replies ! View Related

Backup Strategy - SQL2005 Tools Versus 3rd Party Tools
I am running SQL Server 2005 x64 Enterprise under Windows 2003 x64 Enterprise. My current backup strategy uses T-SQL jobs run by SQL Agent (writes out *.bak files) and then I have an Integration Services job that copies the *.bak files to our NAS device. I have performed a restore without issue. The jobs are all automated every four hours via SQL Agent. Is this a sound strategy or are there additional benefits to using 3rd party tools? If so, what are the advantages and which tool provides them?

View Replies ! View Related

Design Tools / Sql Server Mgt Tools Cause Login Fail
Login failed for user 'TOSHIBA-USERASPNET'
I know that the file persmission for the web application have to include aspnet, so i keep resetting the folder permission for aspnet in file manager, but the login failed keeps coming back every day or two
problem is after working with VS05 Pro, SQL Server Management Studio CTP, somehow the aspnet persmission get changed, use alot of sqldatasource wizards and often there is a conflict/hang between the datasource wizard and the need to have the mdf in a dettached state within VS server explorer,
not sure but the procedure to fix this seems to be to reboot, detach and re-attach the mdf in the Sql server Studio tool, re-apply the aspnet file permission on the web app folders (wonder should i be doing this in IIS instead), make sure the mdf within server explorer is detached, the it works
anyway, getting real tired of the resulting delays and design time derailment, clues greatly appreciated, thanks
sometimes i can use View in Browser when in VS05 form view and i wont get the aspnet folder permission error and other times i do.
last thing, is it a bad idea to give aspnet full permission for the entire web applicaiton??

View Replies ! View Related

Server Tools Or Client Tools?
Dear All,
how can we know that wether we had server tools or client tools on my machine?

Arnav
Even you learn 1%, Learn it with 100% confidence.

View Replies ! View Related

Tools Tools Tools For Performance ???
Know any good performance monitoring and analysis tools for SQL server.

View Replies ! View Related

SQL Monitoring
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?

View Replies ! View Related

Monitoring
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.

View Replies ! View Related

CPU Monitoring
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 ?

View Replies ! View Related

CPU Monitoring
Hello,

Is there a way I could get the total cpu usuage of the box other than Task Manager and Profiler

Thanks
Rea

View Replies ! View Related

SQL Monitoring
Hello,

I am looking for a reliable and easy manner to poll a domain for any box running the sql server service. Our current monitoring tool doesn't do this.

Many thanks!

View Replies ! View Related

Health Monitoring And IIS
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

Thank you in adance!
Jon

View Replies ! View Related

Monitoring MSDE
Hi, i would like to know if there is a tool that can monitor the MSDE , ex how many T-SQL that is executed, how many broken connections, i know SQL-server has a "performance monitor" but does MSDE has something similiar?

View Replies ! View Related

Sql Performance Monitoring
i am looking for new ways to monitor my sql servers. are there anynumbers in sql that can indicate a performance problem? i would liketo stay away from the performance monitor included in windows and havenumbers that i can trend and provide to management.Thanks.

View Replies ! View Related

SQL 2K Backup Log Monitoring
Greetings,I'm looking for a little guidance. I work for a medium sized bankwith about 20 SQL servers in 2 locations. We have two backup schemes -Less critical SQL boxes have nightly DB backups and Transaction Logdumps, more critical boxes have additional hourly transaction dumps.The database maintenance should be deleting any backups more than 2days old (Should have been picked up by system backups and moved to SANby then).My question: Sometimes the SQL backups fail, usually for lack ofdisk space. As it stands now it's a tedious process of reviewing thelogs of each of the 20 servers to check for failure. Is there a productthat can centralize these logs or give meaningful errors on failure?I'm not real keen on using the email/pager reporting function fromthe DB Maintenance. We have 4 techs who rotate on reviewing the logsand we don't want to receive unnecessary emails 75% of the time or haveto change the account info every week.Any suggestions would be appreciated.Thank,Jim

View Replies ! View Related

Monitoring Deadlocks
SQL 2000 SP3Howdy all.I saw some code out there somewhere that logged deadlock info includingSQL code that caused it as well as the user information.Any ideas ?Thanks,Craig

View Replies ! View Related

Monitoring Software
Hello,Our SQL Application is supported by SQL servers and non-SQL servers. Wehave software to monitor all the SQL servers remotely (SQLDiagnosticsby Idera) and SQL changes to both SQL and the server it runs on,(SQLconfig by Idera).I have a need to do remote monitoring of the non-SQL servers formperformance and any changes to the server (new users, patches, additionof new software, removal of software and so forth).I know this is a bit off topic, but I hope someone here has simularneeds to monitor their entire SQL enterprise.Does anyone know of an enterprise solution to monitor and track changesto Windows 2003 servers?TIARob

View Replies ! View Related

Monitoring Replication
We're suffering from SQL replication issues - every now and again, thereplication dies, citing "General Network Error" as the cause. The firststep to sorting this is finding out when it happens, but as we only noticeit when the app that uses the database dies, this is a little problematic.We have a network monitoring system that knows about WMI, but I have noidea which performace counters to watch - there doesn't seem to be a handy"number of replication erors" counter or anything of the kind. Can someoneenlighten me as to which counters we could use?Thanks,RR

View Replies ! View Related

Need Help On Performance Monitoring
I was wondering if the CPU is the bottleneck. Hence I used the PerformanceMonitor to look up some values. Here are the results.Counter Scale Average MaximumMinimum%Disk Time 1 2.74 24.9320Current Disk Queue Length 10 0.090 6 0Buffer cache hit ratio 1 99.752 99.75299.751%Processor Time (Total) 1 2.307 9.6880.313%Processor Time (sqlserv) 1 1.218 7.188 0Processor Queue Length 10 6.960 11 5The thing that puzzles me is that the Processor Time is quite low but theProcessor Queue Length is very high. Why is the processor processes queuingup when the processor not bogged down ? I would assume both values to be onthe high side. Is the high buffer hit ratio an indicator that the CPU iswaiting for some reads from the buffer before processing the next process?The users often run reports on historical data. That might be the reason forthe high buffer hit rates.Am I monitoring the wrong values ?Any advise would be very much appreciated and thanks in advance.Pit

View Replies ! View Related

SQL Server Monitoring
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

View Replies ! View Related

Website Monitoring
I am offering free basic website monitoring, looking for some peopleinterested in trying it out.http://www.mjcsoftware.com/main.asp?page=servicesThanksMike Curry

View Replies ! View Related

Database Monitoring
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.

Thanks
Kishore

View Replies ! View Related

DB Monitoring Tool
Hi all,

I am new to the db world so please let me know if I don't make any since.

I was wondering if there is an open source SQL database monitoring tool out there that I can run on my desktop that would give me a log of what is going on on the database (or the server).

Thanks.

View Replies ! View Related

Monitoring The Db Size
Hi All,

I'm wonderring if someone has the script which can run on each server to get all dbs size , free space on this server ? Curently I am using the enterprise manager to check the db space usage manually, but this is very frustrated due to a server has many dbs located on it

Thanks,

View Replies ! View Related

Monitoring SQL Server
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.

View Replies ! View Related

Automatic Job Monitoring
I'm a SQL Server 7/2000 DBA and manages about 40 servers in different networks. Every morning I check through the Enterprise Manager if all Jobs (backup, maintenance, etc.) have run successfully. This check costs me 1 hour per day.

Because of a reorganization I've got some new college's and lost some college's. My new college's think this is to much work, so it should be automated. They only want the failed jobs to report an error on a website or something like that, and don't want to check 40 servers. I don't agree in this, because I'm affraid I'm going to miss some errors.

How do you do your checks every morning?

Thanks,

Marco

View Replies ! View Related

Performance Monitoring
Hi,

I want to collect performance measures regarding the import of data
and the growth of resulting extract_tables.

I use - say - 15 tables from a erp-system (like JDE Edwards)
to build a -say - sales-warehouse and a MS-OLAP-cube.

For every incoming table I got a dts-package witch is
protocolled into msdb.sysdtspackagelog.
Every package got the name
[Build]_[Subsystem]_[Table_name]
e.g. JDEdwards_Sales_F0005
The destination table is namend e.g. extr_F0005

Now:
With a seperate DTS-package I transport the
records from msdb-db into my build-db
- say - JDEdwardsExtract.
Name: extr_performance_monitor
(eventually filter on buildname, because there are several builds in
my system)

So this result is quit good and easy to handle for
seeing elapsed time per day.

But the dtslog won't tell me, how many records the dtspackage
had to copy.(and there is one at least with no records (Cubeupdate))

Now the count(*) comes in.

In the dts-package
sys...log ---- to --- extr_performance_monitor
I added the columns
extr_table_name,
extr_table_rowcount,
extr_table_timestamp.

With
select name, 'extr_' + replace(name, '[Build]_[Subsystem]','') as
extr_table_name from extr_performance_monitor
I cut the original dts packagename down to the extr_.. name.

But I don't have a clue how to solve the count(*)

Example:
dts_package_name,.... , extr_table_name,extr_table_rowcount, extr_table_timestamp

[Build]_[SS]_[F0005], ..., extr_F0005, 0, sysdate.

I think about a package wich is running after the last
data_import (and cube_refresh) is done.
(but the same day)

So the result could be:

Table_name (as dimension category)
Time to perform
Number of records in import table
Records per second.

The next step could be to look for required space.

The result should be a grafik - say - over 12 month
were you can easily see the amount of data performend
time consumend, (table space used),
and - very important -
you could extrapolate your hardware requirements.

Looking forward for any hints.

Thanks in advance.

Michael

View Replies ! View Related

Performance Monitoring?
My SQL Server 2000 system is pegged. Disk activity is maxed out and system is very unresponsive. Several people have database tasks running through this system and I'm pretty sure there is a single application that is the culprit and I'd like to identify which one.

Does anyone have any practical tips on using "Process Info" in Enterprise Manager? What units are CPU and Physical I/O displayed in? Why does the column sort on these fields not work as expected?

Do I just pick the process with the largest Physical I/O and assume that's the problem?

View Replies ! View Related

Performance Monitoring
Does anyone know of a way to determine which SPs or which tables are being accessed the most heavily or often from an application? I have inherited a site that is heavily used, but poorly tuned. However we have distributed C/S apps that hit the server and do not contain debug code. In addition, the SPs are encrypted and I do not want to replace them in the short term with new SPs that log hits.

I realize I can use triggers, but is there any other method?

View Replies ! View Related

SQL Server Monitoring
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.

View Replies ! View Related

Monitoring Tempdb
Is there any way to watch the activity of the tempdb in 6.5 similar to using 7.0's profiler. I would like to see how often it is utilized and how large it grows during utilization. Any help would be appreciated.

Thanks,
David

View Replies ! View Related

Performance Monitoring
Hi

I am learning SQL SERVER ..Can anyone tell me how do I tune a given stored procedure in 6.5 and 7.0.?

In performance tunning which counters are really necessary to watch and the remedies to be taken?

Thanks
Reddy

View Replies ! View Related

Monitoring Tool For SQL
Does anyboby have any recommendation of what is the best tool for monitoring SQL Server, such as spaces, device, etc...

Thanks.

View Replies ! View Related

Monitoring Usage
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?

Thanks.

View Replies ! View Related