Monitoring Tools.

Jul 20, 2005

All, I seek your knowldege. I am looking for a monitoring tool that
has the abilility to page and email me should something go wrong with
SQL server. I know of two such tools: 1.) BMC Patrol, and 2.) Quest's
Foglight. I was hoping that some of you have had some experience with
other such tools. Let me know please.

Louis

View 1 Replies


ADVERTISEMENT

Monitoring Tools

Dec 22, 2004

Hi all,

I'm looking into the possibility of buying (as I doubt there's any good free options) a SQL Server Monitoring tool.

Has anyone got any particular recommendations - good or bad? I know a little about Spotlight, but not much else.

Thanks in advance.

---------------
zinedunc

View 2 Replies View Related

Monitoring Tools

Mar 7, 2007

Hi,

We are evaluating proactive monitoring tools for our heterogeneous database environment, currently comprising of Sybase and MS SQL Server.

Our current options are Bradmark Surveillance, Quest Foglight/Spotlight, MOM (SQL Server only) & Embarcadero Performance Center.

Are there any recommended tools from your experience? Or any tools with with you have had bad experience?

Tia.

View 2 Replies View Related

Server Monitoring Tools

Jun 14, 2000

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 2 Replies View Related

MS SQL Server Monitoring Tools

Feb 19, 2004

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 1 Replies View Related

Tell Me Some Third Parts Monitoring Tools

Mar 15, 2002

Hi, gurus:

Please tell me some third parts monitoring tools for MS SQL server 2000.

View 1 Replies View Related

3rd Party Monitoring Tools

Apr 11, 2002

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 2 Replies View Related

Tracking Changes And Monitoring Tools

Aug 19, 2007

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 2 Replies View Related

Performance Monitoring Tools For SQL Server

Aug 29, 2001

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 1 Replies View Related

Favorite Monitoring (Performance) Tools?

Apr 25, 2007

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 2 Replies View Related

Tools For Monitoring Sql Database Access

Feb 2, 2008

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

View 5 Replies View Related

Database Change Management Tools - Monitoring Changes?

Jun 25, 2012

Have audit requirements that require that all schema changes to certain database are tracked and monitored. Any tools that can monitor these changes and log them for audit review?

View 3 Replies View Related

SQL 2012 :: Monitoring Tool Using Powershell And Performance Monitoring

Sep 15, 2014

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.

View 2 Replies View Related

SQL Tools :: How To Disable Customer Improvement Program From Menu For Server MGMT Tools 2012

Mar 25, 2014

Am customizing SQL server MGMT tools 2012 for Mass deployment.Client had asked to remove Customer Feedback option from help menu.how to disable that.

View 6 Replies View Related

SQL Tools :: R2 Management Tools Install Fails - Specified Account Already Exists

Oct 20, 2014

The installation SQL 2008 R2 Management Tools on a Windows 7 workstation fails with the error, The specified account already exists.

Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

  Exit code (Decimal):           -2068052700
  Exit facility code:            1212
  Exit error code:               1316
 
[code]...

View 10 Replies View Related

Backup Strategy - SQL2005 Tools Versus 3rd Party Tools

Jun 1, 2007

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 3 Replies View Related

Design Tools / Sql Server Mgt Tools Cause Login Fail

Sep 20, 2007

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 2 Replies View Related

SQL Tools :: Tools To Determine Version From BAK File

Apr 24, 2014

Is there - apart from the notorious RESTORE HEADERONLY - an tool which is able to tell which SQL Server version created a specific BAK file? I'm looking for a tool that can be used w/o an available/running SQL Server installation.

Alternatively, is there any documentation about what is read with RESTORE HEADERONLY so I could write a tool myself?

Where would I find the version "bytes" in a BAK file?

View 4 Replies View Related

Server Tools Or Client Tools?

Jun 16, 2008

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 1 Replies View Related

Tools Tools Tools For Performance ???

May 16, 2002

Know any good performance monitoring and analysis tools for SQL server.

View 1 Replies View Related

CPU Monitoring

Jul 31, 2002

Hello,

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

Thanks
Rea

View 1 Replies View Related

CPU Monitoring

Aug 16, 2000

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 2 Replies View Related

SQL Monitoring

Mar 26, 2007

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 3 Replies View Related

SQL Monitoring

Jul 23, 2005

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 1 Replies View Related

Monitoring

Jul 20, 2005

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 2 Replies View Related

Health Monitoring And IIS

Feb 5, 2007

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 2 Replies View Related

Filegroup Monitoring

Jun 21, 2002

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!

View 1 Replies View Related

Monitoring Server

Jul 10, 2002

Hello,

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.

Any idea or guidance is appreciated

Thanks
Roma

View 2 Replies View Related

Login Monitoring

Sep 4, 2001

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.

Please Advise, and thanks in Advance.

View 2 Replies View Related

Performance Monitoring

Apr 5, 2000

Hi,

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.

Thanks.

View 1 Replies View Related

Performance Monitoring

Apr 17, 2000

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 3 Replies View Related

SQL Server Monitoring

Jul 8, 1999

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 2 Replies View Related

Database Monitoring

Jan 19, 2005

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 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved