August 14, 2014 at 9:04 am
Just like to know which performance Monitor tool you guys use to monitor SQL server such as, Data collector set, Data collection (from SSMS), Perfmon, Profiler, DMV...........
How about Data Collection (thru SSMS) this is pretty simple to setup, is there any 'Cons' using this tool?
Thanks in advance.
August 14, 2014 at 9:29 am
dinsab11 (8/14/2014)
Just like to know which performance Monitor tool you guys use to monitor SQL server such as, Data collector set, Data collection (from SSMS), Perfmon, Profiler, DMV...........How about Data Collection (thru SSMS) this is pretty simple to setup, is there any 'Cons' using this tool?
Thanks in advance.
It depends on the day and the need.
I have used all of them for one thing or another.
You did forget a couple: server side trace, extended events.
Data Collectors (performed via setup in SSMS) are useful and customizable. They will run on a routine basis and can lead to some good historical data for trending and analysis. I have used it to create custom DCs to bring various things from extended events into historical tables.
It really boils down to what you need. I would typically stay away from profiler except in the case of using it to quickly create a server side trace (script the profiler setup and then use that for a server side trace).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 14, 2014 at 9:35 am
Thank you much for quick and nice reply. Just wanted to ask you again, Data Collection (SSMS) needs to create a Database or table and there are lots of job get created on Sql agent. Would that make server to slow down or load will add on the server?
Regarding Server side trace, how can I set up 'start' and 'stop' time?
Thank you again.
August 14, 2014 at 9:43 am
Any thing you add to the serve to collect data and "monitor" will add some load of some sort.
Data Collectors are usually fairly lightweight.
For the server side trace - here is an article http://www.sqlchicken.com/2009/07/how-to-create-a-server-side-trace-with-sql-profiler/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply