DKY (3/10/2014)

---

The output of that query shows 2,680. I don't know how to check the others.

Task manager shows that sqlservr.exe is currently consuming 4,266,016k on the "Processes" tab but on the "Performance" tab I show that the server itself is consuming 15.5GB of the 16GB of memory.

When I run those NET STOP commands from the cli

NET STOP "SQL Server Agent (BRKSQL02)"

NET STOP "SQL Server (BRKSQL02)"

The 15.5GB goes down to around 800MB after about one minute (it's a slow decrease which I also find odd, I would have thought it would be immediate).

I then start the services back up again after about 10 minutes of 800MB and it starts using up to the 15.5GB again.

When I run:

SELECT

SERVERPROPERTY('productversion'),

SERVERPROPERTY ('productlevel'),

SERVERPROPERTY ('edition')

I get:

My Product version = 10.50.1600.1

My Product Level = RTM

My Edition = Standard Edition (64-bit)