Viewing 15 posts - 4,861 through 4,875 (of 7,168 total)
Jack Corbett (3/16/2012)
March 16, 2012 at 8:31 am
What did I wander into with this thread? 😛
My best guess is you have something running that has a memory leak. Can you restart the server after disabling each of...
March 15, 2012 at 4:00 pm
Post a screenshot.
March 15, 2012 at 3:48 pm
Sorry, I see no evidence of 98% memory use. SQL is using 1.94GB and is the largest consumer of the 2.83GB being used by all processes collectively.
From your original post:...
March 15, 2012 at 3:37 pm
I second everything Jeffrey said.
msdb.dbo.sp_purge_jobhistory is the proc you want. I run it on all my instances regularly via a SQL Agent job.
March 15, 2012 at 3:18 pm
Please run this from a PowerShell prompt and post the results:
Get-WMIObject Win32_Process | Select Name,@{Name="WorkingSetSize(MB)";Expression={"{0:N1}" -f($_.WorkingSetSize/1mb)}} | Sort-Object Name
This will show us the list of all processes running on your...
March 15, 2012 at 3:13 pm
From your original post:
Why if I have the max memory limited to 4 GB... the VM Reserved shows 8 GB... and the physical memory used by the process is just...
March 15, 2012 at 2:22 pm
juanc.aguirre (3/15/2012)
opc.three (3/15/2012)
-- top 10 consumers of memory
SELECT TOP 10
...
March 15, 2012 at 2:01 pm
That makes perfect sense, and was a weakness of WHERE-clause JOINS due to the ambiguity of such things.
This is an example to run in your 80 compat mode DB to...
March 15, 2012 at 1:58 pm
Run this one too please and post the results, this one includes multi-page allocations:
-- top 10 consumers of memory
SELECT TOP 10
type,
...
March 15, 2012 at 1:46 pm
Do you use Linked Servers heavily on this particular instance?
March 15, 2012 at 1:42 pm
Lynn Pettis (3/15/2012)
Have you tried this with code where additional equality comparisons were actually part of the LEFT (or RIGHT) OUTER JOIN and not filter criteria?
Some of the queries I...
March 15, 2012 at 1:40 pm
What does this return on your instance:
-- top 10 consumers of memory
SELECT TOP 10
type,
CAST(SUM(single_pages_kb)...
March 15, 2012 at 1:29 pm
Here's a little cheat for you using the Query Designer in SSMS 2008R2.
1. Restore a copy of your database into a DEV environment.
2. Change the database to 80 compatibility mode.
3....
March 15, 2012 at 1:13 pm
You could add a persisted computed column that consisted of SomeText (from Matthew's sample code) collated with the BIN collation you need, and then add a non-clustered index to...
March 15, 2012 at 12:34 pm
Viewing 15 posts - 4,861 through 4,875 (of 7,168 total)