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
ADVERTISEMENT
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
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
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
Mar 30, 2004
Hello,
I need an Administration tool for SQL SERVER 6.5 compatible with WINDOWS 2000.
When I try to search one with GOOGLE, I find none ...
If anyone can provide me with any solution, he (or she) will make me the most happy of the DBAs today ...
Thanks in advance
Al'
View 1 Replies
View Related
Apr 23, 2008
I have a Linux machine here at work that I do some development on, along with a few other tasks. It's also on my primary machine at home. Is anyone aware of a SQL Server Management suite that will run (natively - not in a VM) on Linux? I've used Aqua Data Studio in the past, but I would rather not have to pay for another License just for a part-time use.I'm not looking for a full suite of graphical utilities. If I could get the basic functionality of Query Analyzer (query window, object scripting, etc..), I'll be happy.I've googled around, and the pickings have been rather slim. The only thing I've found is something called Transact-SQL Analyzer (http://sourceforge.net/projects/sqlanalyzer/). I haven't tried it yet, but I'll give it a shot. Has anyone used it before? It doesn't make mention of 2k5 support, either.
View 6 Replies
View Related
May 14, 2008
I was looking for a 'free' intellisense tool that will prompt me with options when I am writing stored procedures in SQL Server Studio. Very much like the intellisense in Visual Studio.
Does someone know about such a tool? I know there are tools of this type but they cost 600 to 1000 dollars for a single user.
View 2 Replies
View Related
Jan 28, 2005
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 2 Replies
View Related
Jun 16, 2007
Hi guys!
I have built a website using asp.net 2005 that uses sql server 2005 database,
my question is,
which tool can I use to monitor the connections to the database,
because I feel that some of them are left open for a very long time.
Thanks in advance!
View 4 Replies
View Related
Jul 23, 2005
I am in the process of evaluating some SQL Performance Monitoring /DBAtool to purchase (For SQL Server 2000). I have the following list ofsoftware that I came across and have to finalize which one to recomendfor purchase by my company.Quest Central® for SQL ServerPerformance Center by Embarcadero (dbartisan)Performance analysis by BMC Software solutionsSQL Server Management by netIQI would greatly appreciate if anyone can give me a comparison/ anysuggestions on the above mentioned applications...!Has anyone used/currently using any of these applications? Pleaseadvise...Thank you in advance...!
View 7 Replies
View Related
Mar 22, 2006
Hi:
I removed the publication from the database but it is still showing in the monitoring tool. Does anyone know how to remove it from there?
Thanks
View 5 Replies
View Related
Jul 10, 2007
I'm looking for a free tool akin to SQL Server Enterprise Admin that i can use to administrate some of my databases on remote hosting from my home PC... any recommendations?
View 2 Replies
View Related
Aug 17, 2005
AgileInfoSoftware LLC is proud to announce AgileInfoSoftware PowerQuery*4.1 release. PowerQuery is free database query tool to work with multiple databases simultaneously and effectively.
The key features of PowerQuery 4.1 are:
One unified user interface works with*all your databases. No need to switch from one database to another.
Easy to build and execute query.
Use native database connectivity to improve database query performance.
Graphical*table edit and commit change without writing any INSERT, UPDATE or DELETE statement.
Automatically monitor Oracle Server side activities, such as executed SQL statements, server memory usage, disk usage and many other performance measurements
To obtain free PowerQuery 4.1, go to http://ww.agileinfollc.com. After download and install the software, send the registration code (32 bytes hash string generated based on your installation time) to support@agileinfollc.com, we will send back free license code to activate the software permanently.
View 1 Replies
View Related
Nov 6, 2006
dun need sophisticated interactive reports, but just simple basic rigid reporting will do :D
looking for a simple tool for my end users. Crystal Reports a bit overkill.....
View 10 Replies
View Related
Jun 23, 2008
Hi Everyone,
I am looking for a tool which can store SQL I/O and network/sec data. According to this historical data, I can decide whether upgrade my hardware.
Is there any free tool?
View 3 Replies
View Related
Aug 6, 2007
Hi everyone,
I am looking for sql monitoring tool. I have found tools from Idera and Quest but the price is a bit expensive.
The tool I am lloking for is able to show historical information such as CPU/memory/disk usage.
Any good suggestion? Thank you in advance.
View 1 Replies
View Related
May 10, 2008
HI
I am trying to find a pure web based backup restore tool that can be used on MS SQL 2000.
I have found a few that claim to be web based, but then it tells you to log into your MS SQL server and make some adjustments.
I know that microsoft Enterprise manager comes with a backup / restore tool. but 1) i dont want to have to install a complete copy of 2005 server, and 2) i dont hav ethe physical space to do it right now anyway. all i need to do is move 2 databases from one account to another.
thanks
View 3 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
Jan 20, 2004
Is there a Free GUI for SQL server that can control or edit any and all the records in it, and the tables?
View 2 Replies
View Related
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
May 7, 2014
What are the events to be monitored for a Active/Passive Cluster?
View 4 Replies
View Related
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