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


ADVERTISEMENT

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

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

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

Monitoring Tools.

Jul 20, 2005

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

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

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

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

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

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

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

Monitoring SQL Server

Nov 7, 2005

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

Monitoring SQL Server

Dec 5, 2006

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.

Thx in Advance
Sat

View 3 Replies View Related

SQL Server Monitoring

Jul 20, 2005

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

Monitoring Using Sql Server

Sep 26, 2007

Hi,

Could u pls tell as to how to find the size of a transaction or monitor it on a server using sql server 2005????

Regards
Rohit

View 1 Replies View Related

Monitoring Server Up Time

Dec 3, 1999

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.

Thanks in advance.

View 1 Replies View Related

Monitoring SQL Server In Another Domain

Aug 17, 2000

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.

View 2 Replies View Related

Monitoring SQL Server Transactions

Mar 22, 2006

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!

View 1 Replies View Related

Monitoring And Administrating Sql Server

Mar 24, 2006

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

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

SQL 2012 :: Monitoring Clustered Server

May 7, 2014

What are the events to be monitored for a Active/Passive Cluster?

View 4 Replies View Related

Reqs For Log Shipping Monitoring Server

May 29, 2008

Does anyone know if there are any minimal hardware requirements for the Monitoring server for SQL 2005 Log Shipping?

View 1 Replies View Related

Recommendation Os SQL Server Monitoring Tool

Aug 14, 2006

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

View 2 Replies View Related

SQL Server Integration With Monitoring Tool

Aug 18, 2007

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

View 3 Replies View Related

SQL Stripes - Free SQL Server Monitoring Tool

Sep 25, 2003

http://stripes.docmusic.com

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

Thanks and enjoy!

View 3 Replies View Related







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