Hello, since I haven't found any good references on the web I thought I just might ask you all experts what tools do you [suggest]/use with number of MS SQL Server 2000 & 2005. I need to assemble toolbox which would cover: - backup - transaction log browse/recovery - audit - configuration change/compare management (ie deploying changes to other servers, compare schema and config) - performance I know it's a big field and I might have quite a budget for this, but I would still like to hear what is really good and useful (as in high-end and in midle price range). Thanks
Backup: Red Gate - Quest Rescue : Red Gate Audit :http://www.sql-server-performance.com/krell_omniaudit.asp http://www.sql-server-performance.com/da_dbaudit_spotlight.asp Configuration ...: Red Gate Performance : Diagnostic Manager (Idera), Spotlight (Quest), SQL Tools. Luis Martin Moderator SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important Bertrand Russell Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte All postings are provided “AS IS†with no warranties for accuracy.
There are many spotlight are availvble inhttp://www.sql-server-performance.com/spotlights.asp Recsue - Log P.I. But most of them have not released for SQL Server 2005. ---------------------------------------- http://spaces.msn.com/members/dineshasanka
Performance and Capacity Planning: The one thrid party tool that our company uses is called DBPerform from Ashgrove Software (ashgrovesoftware.com). This tool is much more than a stress testing tool which it gets compared to and is how we found it. It allows us to model a client's workload by defining the transactions which make up the clinet's workload in what it calls a Workload Library. Then in the Execution Package tab you select specific items from the Workload Library to makeup the scenario you wish to test at that particular time. You can control all aspects of the execution environment, log the results to text or XML logs, concurrent connections/threads, interval release, interractively TPM during execution, and so on. It is part of our "tool kit" that each of us carries on client gigs. It very inexpensive compared to other full workload simulation and benchmarking products.
quote:Originally posted by dineshasanka There are many spotlight are availvble inhttp://www.sql-server-performance.com/spotlights.asp Recsue - Log P.I. But most of them have not released for SQL Server 2005. ---------------------------------------- http://spaces.msn.com/members/dineshasanka Dineshasnka, You mentioned Log P.I. I checked them out from Google search and found them now part of a company called Goldengate. They did not have much info. I am curious to know what became of the old product and if anyone knows about how the technology will be used. Thomas "Okey dokey... free my mind. Right, no problem, free my mind, free my mind, no problem, right... "
http://www.sql-server-performance.com/news_logpi.asp http://www.sqlservercentral.com/columnists/dcorey/reviewlogpi.asp http://www.aspfaq.com/show.asp?id=2449 - relevant information. Satya SKJ Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thanks Satya. Very helpful links. "Okey dokey... free my mind. Right, no problem, free my mind, free my mind, no problem, right... "
quote:Originally posted by alpha_cen Hello, since I haven't found any good references on the web I thought I just might ask you all experts what tools do you [suggest]/use with number of MS SQL Server 2000 & 2005. I need to assemble toolbox which would cover: - backup - transaction log browse/recovery - audit - configuration change/compare management (ie deploying changes to other servers, compare schema and config) - performance I know it's a big field and I might have quite a budget for this, but I would still like to hear what is really good and useful (as in high-end and in midle price range). Thanks You mentioned a high budget and that would be where you would find Lumigent but they have not released a new Log Explorer in ages. No news in sight either. I am curious if anyone is using Log Explorer and what the word on the street is for a new release? I don't believe they are a sponsor here but they are (or at least were) a player in this space. Thomas "Okey dokey... free my mind. Right, no problem, free my mind, free my mind, no problem, right... "
