Hi Guys ,

Thank you for taking time to reply to this thread . Much appreciate it.

I run this script :

SELECT *

FROM sys.dm_os_wait_stats

ORDER BY wait_time_ms DESC

GO

The result is as below (...

It will still be my concern because memory is very high ( 96%)

Then how do I solve that issue and slowness as well ?

My concern is why the memory becomes very high even tho it has been capped since a long time ago .

Very curious

Hi ..

Thank you very much on your feedback . I have asked this question to my co-worker but no feedback so far . I will get back to you...

Hey .. i hv tuned some highes queries and the application still slow ..i am thinking there might be something outside database .. btw this is CRM application .

i think this is even worse

a query which runs once an hour and does 1 million reads

Am I right ?

Btw I have tuned the highest Query so far and the logical read drop to 5 from 900.000 , But user still complains about slowness .

Would it be due to...

OK . Thanks for the reply Gail !

Thanks for the reply Gail . Much Appreciate it .

Hmm My team just checked the graph .. It was spiking from 4 PM - until 4 :17 PM

and I...

Hi Guys

A bit update ..

I ran Profiler from client side ( Tool – Profiler )

Thanks so much Gail

That’s a very good Information for me! I will work it out with my team

Hi Guys ,

I just run the script from Extended Event and here what I get ( but I still don’t know what is the cause of this deadlock ) –...

HI guys ,

I got something from Error Log but I couldn’t read the deadlock culprit ( The result as attached )

I assume the yellow highlighted is the Victim and...

Thanks so much Gail !!

I just enable it using DBCC TRACEON(1222,-1)

and will see how it goes

Can I turn it on forever ? just in case one day I need...

OK COOL . Thanks for that

Btw how do I catch the deadlock process so I will know which queries that are involved at specific time?