arr.nagaraj (3/11/2010)

---

Hi Jason,

Thanks Jason.

My experience has shown that sustained growths typically come from long running transactions. Many times those transactions finish before somebody can get into the system to find...

The solution by Eralper should work just fine.

Thanks for the training. This looks to be very beneficial to the community.

arr.nagaraj (3/11/2010)

---

Hi Jason,

The reason i felt getting sleeping ones are also better is because we would increase the chances of finding the actual queries. And at times if we have...

Lynn is correct on this. Let me throw in that you should evaluate which method suits your environment best. If you have purchased processor licenses, there is no...

arr.nagaraj (3/11/2010)

---

Hi Jason,

The query you used to capture tsqls doesnt capture sleeping connections. Was that intentional? I would prefer to grab the sleeping ones as well so that I...

Congrats.

Thanks Paul. After submitting the article and taking another look at it, I found a few things that could have been changed to improve the scripts. I bet...

At the risk of sounding like an echo (again again again again), I agree with homebrew and Lynn.

SQL Ping would not need to be installed on any server. It would be installed on a desktop and search the network for instances of SQL Server (all versions).

You...

Thanks for the question. Nice job.

I like option 2. The problem with option two is that you will have to figure out the logic to determine when to run the script, which jobs to...

Paul White (3/10/2010)

---

No apology from me - I gave my best answer based on the question asked, before considering the relative merits of the carpet-ation-ization of a warehouse.

Carpeted soles seem...

Something like that.

You're welcome.

As for mash and skins - depends on my mood and the flavor.