performance counters
trying to use Performance counters to identify how my SSIS packages use system resources. i captured the log with couple of counters. i see sudden spike in usage of buffers; want to track down more details about this. what should be the ideal approach to use perf counters??
January 22nd, 2011 3:57am

As an overview you can read this article: http://msdn.microsoft.com/en-us/library/ms137622.aspx But choosing the best approach always depends on your scenario. Typically, a developer would want to "profile" his/her new package before moving it to production. So you would initially use the Perf Counters and get an idea what kind of memory usage will occur. As an aside, we as SSIS developers, rarely deploy packages to "weak" systems (stems from the fact SSIS would be deployed on an enterprise grade machine capable to cope with loads), and another factor: since it is ETL, loads can change overtime, so you never know how much memory a package will be using say in a year from now, so may be, unless you are doing something huge, you should not spend too much time trying to measure your package.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2011 4:12am

Here is an article about best practices that also includes some information on the Performance Counters: http://www.mssqltips.com/tip.asp?tip=1885Arthur My Blog
January 22nd, 2011 4:37am

i m putting a very basic question about counters. does it help me to identify the problem in my ETL flow in Prod at the time when problem really happened. I only see counters abt memory usage, and other ssis counters. say if the buffer spooling is happening in prod and i want to know what made this happen, how can i check it out? i am trying to explore, and trying to understand its basic needs, where to use it and how to use it. thnks for your response and i completely agree with your point about "measuring the package"
Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2011 4:45am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics