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 (https://blog.sqlauthority.com)

Previous Post
SQLAuthority News – SafePeak version 2.1 for SQL Server Performance Acceleration
Next Post
SQL SERVER – Next Version of SQL Server ‘Denali’ is Officially Named as SQL Server 2012

Related Posts

No results found.

2 Comments. Leave new

  • Martin Andersson
    October 21, 2011 11:17 am
    Reply
  • Martin Andersson
    October 21, 2011 2:09 pm

    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.

    Reply

Leave a Reply

Menu