question

Abankwah avatar image
Abankwah asked

Hello everyone, is it good to load the stored procedure sp_whoisactive on the production server, for performance tuning/

My server is been experiencing slow performance. I watch a video on you-tube and is recommending Adams mechanic stored procedure sp_whoisactive for tuning. I want to know if is save to load that on the production server?
performance-tuning
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you guys Am very much appreciated
0 Likes 0 ·
This web site runs off of votes. Can you please indicate all helpful answers below by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate that by clicking on the check mark next to that one answer.
0 Likes 0 ·
Jeff Moden avatar image
Jeff Moden answered
Adam's code is quite safe. Just make sure that you get it from Adam's website and not off of some You-Tube or other site.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image
Tim answered
100% yes. I pull down each new edition when it comes out and I test it and deploy it to all my production, dev and qa servers. About 250 in total. It is also part of every server build I do. When working with clients I also strongly recommend they install it. As a matter of fact, it is something I check for on their systems as well.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Can you past the right Adam's website here for me please?
0 Likes 0 ·
Tom Staab avatar image
Tom Staab answered
As the others have already said, Adam's procedures are safe in development or production. I also agree that the best way to ensure you get the genuine article is to get it from the source. The procedure you are looking for can be found here: [ http://sqlblog.com/files/folders/release/tags/who+is+active/default.aspx][1] Adam's blog (on the same site) is here: [ http://sqlblog.com/blogs/adam_machanic/default.aspx][2] The latest version of sp_whoisactive is here: [ http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx][3] Here's a reference to that procedure plus 4 others from other well-known SQL experts. We use Ola's backup procedure at work. [ http://sql.richarddouglas.co.uk/archive/2013/06/5-community-stored-procedures-you-need-for-your-servers.html#axzz3OTJuFDlR][4] [1]: http://sqlblog.com/files/folders/release/tags/who+is+active/default.aspx [2]: http://sqlblog.com/blogs/adam_machanic/default.aspx [3]: http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx [4]: http://sql.richarddouglas.co.uk/archive/2013/06/5-community-stored-procedures-you-need-for-your-servers.html#axzz3OTJuFDlR
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.