Detect Memory or CPU Pressure

Easily  ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ Hi there, How do I know that my clients are facing CPU or Memory pressure? Well, the answer is pretty straight forward. Watch the following videos: CPU Pressure: [ Memory Pressure: [ What do I do next once, I find they are facing pressure of the essential resources? Well, identify the queries start exploring what is creating the most trouble and tune them. Here is the example of how I measure the query performance. Query Performance: [ Well, that's it for today. Let me know if you have any question by leaving comments on the video. I offer professional services to help you tune your SQL Server: [( ~ Pinal @ SQLAuthority  To make sure you keep getting these emails, please add pinal@sqlauthority.com to your address book or whitelist us. Want out of the loop? [Unsubscribe](. Our postal address: M.G. Road, Bangalore. India