Jeff, Dev team has no permissions on PROD to KILL or do any admin related tasks.

What I mean to say is, the app team and dba team gets involved in...

Many thanks Jeff. This has become a repeated problem. App team says there is nothing wrong from the application. Blame games gets started for 1 day and eventually they agree...

That's how it is for more than 4 years and even my Senior DBA hasn't changed it.

I know its wiered but thatch how it is. I asked him once, he...

Query your plan cache to see which queries are using the most CPU.  Are you updating statistics regularly?  If not, inappropriate, resource-intensive plans could be being compiled.  Make sure...

For me also, it looks like they aren't closing the connections. I say this bcz all spids are in sleeping state for more than 4 days.

As a DBA is that...

I was able to figure out the client ip address and from using "ping -a <ip>" was able to find out from which machine or app server connections coming from

SELECT

s.session_id,

s.host_name,

s.program_name,

c.client_net_address,

c.local_net_address,

db_name(s.database_id)...

I get what you are saying. Thanks so much Jonathan and others for the help. I will share the results.

I'm assuming that rows are added roughly in CREATE_DATE order. That means you will find the earliest rows on db1 very quickly as no rows have been deleted.

On db2...

Hi All,

I tried to query just 500 rows. But I see a huge difference in Logical scan count. What does it basically say?

set statistics io on

select TOP (500) * from...

• This reply was modified 5 years, 9 months ago by vsamantha35.

How long does it take to do the select on just a small not null column with the same query on both databases? e.g.:

select TOP (50000)...

I know this is blindingly obvious, but put a clustered index on the table (maybe on create_date) - then recompare

you have no idea how many issues you can get...

I reached out to app team, they said Its a history table. We asked the app team if we can create clustered idx on it instead of HEAP but they...

Thanks a Ton 🙂

Okay. Thank you.

John, I have a question. In case of app timeout. if this xabort setting is OFF and assume that app has started a load txn(bulk INSERT), and in between due...