What kinds of performance tools are you using?

Last Post 15 Mar 2008 06:25 AM by TRACEYSQL. 15 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ufohj
New Member
New Member

--
13 Nov 2007 06:52 AM
What kinds of performance tools are you using for SQL2000 and SQL2005?

1. Monitor real time: server, O/S, SQL instance etc.
2. Trend analysis: How healty are server, O/S, SQL instance etc.?

Thanks.
ufohj
New Member
New Member

--
14 Nov 2007 05:01 AM
quote:

Originally posted by: rm
We use openview for os and server, use diagnostic manager for sql.


Thanks rm.
1. What's package of OpenView did you buy from HP? Basic or any other add-on?
2. Do you also use OpenView monitor application and web service?
3. Does any add-on of HP OpenView can do similar things as diagnostic manager for sql?

Did you do some trend analysis? If so, how?

Thanks again.
ufohj
New Member
New Member

--
14 Nov 2007 05:58 AM
quote:

Originally posted by: rm
1. with lot of add-ins, include dbspi.
2. yes.
3. not exactly same. use openview for alerts then dig in with diagnostic manager.



Thanks rm.
1. Can you list the add-ons?
4. Did you do some trend analysis for server, O/S or/and SQL? If so, how?

Thanks.
ufohj
New Member
New Member

--
14 Nov 2007 06:16 AM
quote:

Originally posted by: rm
1. can't since dedicated group handles it.
2. with diagnostic manager for sql, also use standard reports in sql2k5. Server admins handle server and os.


Thanks rm for your kindly help.
Have a nice day.
TRACEYSQL
New Member
New Member

--
24 Feb 2008 05:46 AM
What is use diagnostic manager for sql.

SQLUSA
New Member
New Member

--
29 Feb 2008 04:32 AM
Using:

24/7 SQL Server Profiler

Occasionally PerfMon

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/sql-server-2008-training/ The Best SQL Server 2008 Training in the World!
SQLUSA
New Member
New Member

--
29 Feb 2008 05:52 AM
>24/7 SQL Server Profiler? Are you kidding?

I could be.....but I am not....

SQL Server 2005 (and 2008) Profiler is a fantastic tool in the arsenal of a DBA. Microsoft did a great job with it.

SQLUSA
New Member
New Member

--
29 Feb 2008 11:40 AM
Agreed.

But it does not have a daily/weekly scheduler like SQL Server Agent.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/order2005grandslam/ The Best SQL Server 2008 Training in the World!


SQLUSA
New Member
New Member

--
29 Feb 2008 01:33 PM
>Also, a trace is quite easily scheduled


Details pls. Russell.

Thanks.


Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/order2005highperformance/ The Best SQL Server Training in the World!
SQLUSA
New Member
New Member

--
01 Mar 2008 02:01 AM
Just hit me with your favorite tracing script.

I am going to try it.
TRACEYSQL
New Member
New Member

--
15 Mar 2008 06:25 AM
Quest Software Enterprise is what i use i see everything in one screen shot it - it flashes red from time to time.
ufohj
New Member
New Member

--
27 Mar 2008 10:38 AM
quote:

Originally posted by: TRACEYSQL
Quest Software Enterprise is what i use i see everything in one screen shot it - it flashes red from time to time.


Idera SQL Diagnostic Manager seems better than Quest Software Enterprise.
SQLUSA
New Member
New Member

--
27 Mar 2008 11:40 AM

>Idera SQL Diagnostic Manager seems better than Quest Software Enterprise.

Details pls.

Kalman Toth
http://www.sqlusa.com/order2005grandslam/

ufohj
New Member
New Member

--
28 Mar 2008 06:26 AM
quote:

Originally posted by: SQLUSA

>Idera SQL Diagnostic Manager seems better than Quest Software Enterprise.

Details pls.

Kalman Toth
http://www.sqlusa.com/order2005grandslam/




and speak to their sales and try them by yourself.

I vote 1 for Idera SQL Diagnostic Manager.
SQLUSA
New Member
New Member

--
28 Mar 2008 06:31 AM
Good idea.

I will get a free trial.

Kalman Toth
stefbauer
New Member
New Member

--
31 Mar 2008 10:15 AM
I don't work for them, or have any vested interest.

app manager allows a fully functional tool for 5 monitors. Works GREAT, captures history, both for OS as well as sql server stats etc.

http://manageengine.adventnet.com/p...s_manager/

You are not authorized to post a reply.

Acceptable Use Policy