SQL SPY was designed as a tool to display, monitor and report on valuable SQL Server information. SQL SPY’s reporting capabilities include the Server, Database, and Connection levels.
Requirements and installation :
SQL Spy has been designed as a simple and cost-effective SQL server monitoring tool. It requires and the possibility to connect.Getting the utility on the system is a simple task that should not take too much time. According to the documentation the product is designed to work on Windows 2000, Win2003, and XP and Vista, although we have been able to launch it on Windows 8 x64-bit. On the other hand, during our tests the product showed clear signs of instability as it issued various errors.
Simple looks, features at a glance :
The application window is minimalist and does not show any information until a connection with an SQL server is established. A list with the registered servers is available in the left hand side of the application window.
According to the developer, the capabilities of the program include reporting details about the server itself and the database it holds as well as the connection levels. Moreover, SQL Spy can produce data object biographies complete with dependencies, sizes, indexes, rules, triggers and defaults, stored procedures, user functions and views.
Moreover, the documentation of the product states that user connections can be monitored and recorded without a significant impact on the environment.
It has been a long time since the application was last updated and, as such, it may no longer comply to the current standards. SQL Spy is easy to use, though, and the configuration options are not complicated.
SQL Spy security and download notice :
Download.hr periodically updates software information of SQL Spy from the software publisher (HybridX), but some information may be slightly out-of-date or incorrect. SQL Spy version 5.2.0 for Windows was listed on Download.hr on 25.11.2006 and it is marked as Freeware.
All software products that you can find on Download.hr, including SQL Spy, are either free, freeware, shareware, full version, trial, demo or open-source. You can’t download any crack or serial number for SQL Spy on Download.hr. Every software that you are able to download on our site is freely downloadable and 100% legal. There is no crack, serial number, keygen, hack or activation key for SQL Spy present here nor we support any illegal way of software activation. If you like software product please consider supporting the author and buying product. If you can not afford to buy product consider the use of alternative free products.
Is it safe to download and install SQL Spy?
SQL Spy was checked for possible viruses by various leading antivirus software products and it is proven to be 100% clean and safe. Although, no malware, spyware or other malicious threats was found we strongly advise you to check product again before installing it on your PC.
Please note that laws concerning the use of SQL Spy may vary from country to country. Please be sure that you are using SQL Spy in accordance with the law in your country
SQL SPY on cloud For AWS
Generate data object biographies that include dependencies, sizes, indexes, rules, triggers and defaults, stored procedures, user functions and views. Monitor and record user connections over long periods of time with minimal impact even within the most sensitive production environment.
Major Features of SQL SPY:
Connection Bubble Report: Displays connection information in a graphical bubble display of Waiting, Executing, Blocked and Wait-time connections.
Activity Monitors: This features is actually two features in one. The “Resource Distribution Bars”, displays how the MS SQL Server’s I\O, CPU and Memory are distributed, and the “Activity Graph” which displays the overall activity of the MS SQL Server using ISpySQL’s internal Algorithm.
User Connections: Displays a very detailed grid style report in near real-time of all incoming connections (Includes the ability to terminate a connection, filtering, and you can double click on a connection to produce an HTML report with complete resource Analysis for said connection).
Database Activity: Graphically or textually displays how incoming connections are distributed across databases.
Installation Instructions For Windows
Note: How to find PublicDNS in AWS
Step 1) RDP Connection: To connect to the deployed instance, Please follow Instructions to Connect to Windows instance on AWS Cloud
Connect to the virtual machine using following RDP credentials:
- Hostname: PublicDNS / IP of machine
- Port : 3389
Username: To connect to the operating system, use RDP and the username is Administrator.
Password: Please Click here to know how to get password .
Step 2) On the Start page, type SQL SPY then click on SQL SPY
Step 3) Other Information:
1.Default installation path: will be in your root folder “C:\Program Files (x86)\ISpySQL\SQL SPY 6\”
- Windows Machines: RDP Port – 3389
- Http: 80
- Https: 443
Configure custom inbound and outbound rules using this link
Note : For using this Software , You need to install Any Version SQL Server Express.
Installation Step by Step Screenshots