August 21, 2008 at 2:02 pm
Hi,
I'm looking at two products for monitoring SQL Server performance (disk i/o, pages, memory, etc.). Has anyone had experience with either of the following?
Idera Diagnostic Manager
http://www.idera.com/Products/SQLdm/Default.aspx
Spotlight
http://www.quest.com/spotlight-on-sql-server-enterprise
Thanks,
Terry
A great day starts with a great attitude
August 21, 2008 at 2:50 pm
I have used quest in the past. fairly good product IMO. have not used idea's product.
August 21, 2008 at 2:51 pm
what I found more useful than spotlight is thier product called performance analysis.
August 22, 2008 at 6:38 am
You're comparing apples to oranges. Spotlight is for spot checking performance and Idera's tool is for collecting data long term AND spot checking performance. If you really want to compare apples to apples, you should look at Quest Foglight. I do have a lot of experience with Foglight. That's why we now use Microsoft's System Center Operations Manager and we're looking at Idera's tool as an addition to that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 25, 2008 at 7:05 am
Personally I like Idera's tool because it doesn't require me to deploy some silly agent across all my SQL Server environments.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply