Thanks for the nice explaination and I understood that we need to engage the networking guy. I was checking if there is a way through sql...
Seeking help on below .
Assuming the query execution is slow , I have collected the actual execution plan. What should I look for in...
I would like to know a way to isolate sql server bad query performance is caused by NETWORK and not the sql server.
Are there any...
Can anyone explain the below behavior for HEAP tables?
I have created a small heap table with 3 rows which can easily fit in 1 data page. Not...
Thanks for the wonderful query and suggestions. Thank you very much for the help.
Yes, it doesn't show up the memory grants which have...
Thanks for the reply. It really looks good and whatever you have said is absolutely right.
however , above query doesn't return any results in my...
Checking if anybody has a tsql script to display top 10 high MEMORY consuming queries?
Separate names with a comma.