MS SQL Server Monitoring Tools
Feb 19, 2004We'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?
ADVERTISEMENT
Server Monitoring Tools
Jun 14, 2000I 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.
Performance Monitoring Tools For SQL Server
Aug 29, 2001Hi,
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
Monitoring Tools
Dec 22, 2004Hi 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
Monitoring Tools
Mar 7, 2007Hi,
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.
Monitoring Tools.
Jul 20, 2005All, 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 RelatedTell Me Some Third Parts Monitoring Tools
Mar 15, 2002Hi, gurus:
Please tell me some third parts monitoring tools for MS SQL server 2000.
3rd Party Monitoring Tools
Apr 11, 2002I 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
Tracking Changes And Monitoring Tools
Aug 19, 2007I 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
Favorite Monitoring (Performance) Tools?
Apr 25, 2007I'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.
Tools For Monitoring Sql Database Access
Feb 2, 2008is 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 RelatedDatabase Change Management Tools - Monitoring Changes?
Jun 25, 2012Have 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 RelatedSQL Tools :: How To Disable Customer Improvement Program From Menu For Server MGMT Tools 2012
Mar 25, 2014Am 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 RelatedDesign Tools / Sql Server Mgt Tools Cause Login Fail
Sep 20, 2007Login 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??
SQL 2012 :: Monitoring Tool Using Powershell And Performance Monitoring
Sep 15, 2014We 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 RelatedServer Tools Or Client Tools?
Jun 16, 2008Dear 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.
Monitoring Server
Jul 10, 2002Hello,
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
SQL Server Monitoring
Jul 8, 1999Folks!
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.
Monitoring SQL Server
Nov 7, 2005I 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.
Monitoring SQL Server
Dec 5, 2006Iam 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
SQL Server Monitoring
Jul 20, 2005I 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 RelatedMonitoring Using Sql Server
Sep 26, 2007Hi,
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
Monitoring Server Up Time
Dec 3, 1999My 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.
Monitoring SQL Server In Another Domain
Aug 17, 2000I 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 RelatedMonitoring SQL Server Transactions
Mar 22, 2006Hi,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 RelatedMonitoring And Administrating Sql Server
Mar 24, 2006is 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 RelatedSQL Tools :: R2 Management Tools Install Fails - Specified Account Already Exists
Oct 20, 2014The 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]...
Backup Strategy - SQL2005 Tools Versus 3rd Party Tools
Jun 1, 2007I 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?
SQL 2012 :: Monitoring Clustered Server
May 7, 2014What are the events to be monitored for a Active/Passive Cluster?
View 4 Replies View RelatedReqs For Log Shipping Monitoring Server
May 29, 2008Does anyone know if there are any minimal hardware requirements for the Monitoring server for SQL 2005 Log Shipping?
View 1 Replies View RelatedRecommendation Os SQL Server Monitoring Tool
Aug 14, 2006Our 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 RelatedSQL Server Integration With Monitoring Tool
Aug 18, 2007hi 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 - Free SQL Server Monitoring Tool
Sep 25, 2003http://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!