Hello. I have a strange problem with an application thats eats upp tempdb. I would like to know the tables name and how large this table is. I found a script on the web that solves this but when this application starts eating up tempdb i can only run select statments that have with (nolock)on them and then this script doesn't work
Try adding this before your query:
That essentially applies the NOLOCK hint everywhere. I do not recommend this in most cases, but it's fine for a query like this.
Honestly, though, since it sounds like it's okay to get scripts from the internet, I recommend you check out Adam Machanic's sp_WhoIsActive. It will tell you everything you've asked and more. http://sqlblog.com/files/folders/beta/entry42453.aspx
answered Nov 09, 2015 at 03:47 PM
Tom Staab ♦