I was recently playing with SafePeak‘s performance tuning tool, while I was on their site, I noticed that they have contest running where they are giving away expensive gadgets. The contest has some really nice entries and I few of the participants are my close friends as well. I liked most of the stories. I contacted the contest owners that if I can also participate in the give-away and they have gladly accepted the same. Now you can win my SQL Programming Joes 2 Pros (vol 4) [Amazon] | [Flipkart] | [Kindle] by participating into the contest.
You can share your performance story with community over here. If you share performance story and you are winner – you may win my book through SafePeak but if you share your performance story and leave a comment with your link to story – I will send any five participant print copy of my SQL Wait Stats [Amazon] | [Flipkart] | [Kindle] Â book (anywhere in the world).
Reference: Pinal Dave (https://blog.sqlauthority.com)
2 Comments. Leave new
My problem is rather simplistic in it’s own terms. First a little background information, I’m a consultant and I’ve been working with SSIS for about 1 year now and it’s been a fun ride. However lately I had been running into some performance issue, while moving data from file to stage to dw. SSIS package running time had changed from 30 minutes to 120 minutes, not really acceptable in my world. So my investigation began! I primarly used DETA and SQLP and common sense. This helped me find out that my tables used in SSIS were being used by other people/profiles. Someone had been given access to create index, views, stored procedures in our staging area. After a quick chat with the person, we’ve solved both our issue, I redirected him to the proper database. By both our issues I mean, he was also experiencing the same problems as I with long execution times. Regards Martin.