SQLAuthority News – Your Performance Story – My Contribution to Your Learning

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 (http://blog.SQLAuthority.com)

2 thoughts on “SQLAuthority News – Your Performance Story – My Contribution to Your Learning

  1. 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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s