?
Solved

Solar Winds Database performance Analyzer

Posted on 2016-07-27
2
Medium Priority
?
125 Views
Last Modified: 2016-09-16
We recently used a free version of the Solar Winds db performance analyzer to track some problems we were having with our SQL and Oracle db's.  We thought the tool worked great and it was quite helpful in diagnosing the problems.  We would like to purchase the tool but it is out of the budget at $2000.  What other tools are out there that has similar capabilities at a lower cost?
0
Comment
Question by:NytroZ
2 Comments
 
LVL 10

Accepted Solution

by:
Jason clark earned 1000 total points
ID: 41737021
I've since found out that Toad for Sql Server can generate undo scripts from transaction logs and it is only $701.

Lastly, found an even cheaper option SysTools SQL Log Analyzer and it is only $300.
0
 
LVL 53

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 1000 total points
ID: 41742704
If your company can't afford $2000 for a performance tool then I'm afraid you need to go on with Windows and SQL Server native tools (Performance Monitor, DMVs and Utility Explorer for example).

I even wrote an article explaining how to work with SQL Server Utility Explorer.

For Oracle I can't help because isn't my area of expertise.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question