only a few of IT personnel will have authorize to access it. Access to server recently is to make changes on McAfee and check some of the message in Event...

HI Grant,

This is the current usage of the server since 2 days + after changes made (change OS page file, cost of threshold 5 -> 40, disable scan on mdf,...

GilaMonster (5/22/2015)

---

Are you planning to use it's features? Are you planning to build cubes, do data mining and...

is the following service require to turn on

SQL Server Analysis Service ?

Finally got support from corporate team help to disable the HIP and according to him,

file type like mdf, ldf, ndf already in the exclusion list in on-access scan

Eirikur Eiriksson (5/22/2015)

---

Quick note, if manually...

GilaMonster (5/22/2015)

---

audiocool (5/21/2015)

---

1) Min and Max (Default)

2) Min (0) and Max (28GB)

3) Min (4096) and Max (24GB)

4) Min (5120) and Max (20GB) => Latest

I still have the performance issue until...

TheSQLGuru (5/21/2015)

---

I have had several clients have significant problems with McAfee on production servers, especially SQL Servers. I have never had a client use McAfee on a SQL Server with...

I'm still trying to disable McAfee in this machine at least it did not scan those folder with mdf,ldf. But at the moment, still contact help desk on how to...

Jeff Moden (5/21/2015)

---

Grant Fritchey (5/18/2015)

---

audiocool (5/18/2015)

---

After I adjust the maximum memory as mentioned as above which is 24GB out of my actual machine 32GB, it stay peak at 94 to...

SQLRNNR (5/21/2015)

---

I don't recall reading it, so apologies if this is repetitive.

What is the total memory allocated to this VM?

Do you have a memory reservation set for this VM at...

Now experiencing high memory usage and below is the screen shot:

https://plus.google.com/photos/117684376666431281878/albums/6151506154858339793?authkey=CJaftfXUrce9cQ

Grant Fritchey (5/21/2015)

---

Greg Edwards-268690 (5/21/2015)

---

Grant -

Have you ever seen I/O contention lead to high CPU usage?

I ran into this on a host they decided to use for all nightly backups...

Grant Fritchey (5/21/2015)

---

One of your top queries is from Activity Monitor. You should probably not have it open all the time. You're actually adding load to the server by...

Eirikur Eiriksson (5/21/2015)

---

Quick question, can you post the output of these two queries?

😎

SELECT

OSM.total_physical_memory_kb

,OSM.available_physical_memory_kb

,OSM.total_page_file_kb

,OSM.available_page_file_kb

,OSM.system_cache_kb