RE: What do you use to find out what's slowing down your instance right now

SSC Guru

Points: 1003865

January 19, 2014 at 5:13 pm

Shifting gears...

If I'm on a server that I'm not allowed out {sic} sp_whoisactive on ...

I'd be fighting that tooth, nail, and pork chop. You're the DBA... why aren't you allowed to install some basic DBA tools on some of the servers?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)