Viewing 15 posts - 4,861 through 4,875 (of 7,164 total)
Post a screenshot.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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:...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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,
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 15, 2012 at 1:46 pm
Do you use Linked Servers heavily on this particular instance?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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)...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 15, 2012 at 12:34 pm
I do not know of a way to easily measure throughout at the table-level.
One way that comes to mind, albeit an extremely labor-intensive way, would be to move a table...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 15, 2012 at 12:02 pm
Can you clarify what you mean by "for all tables"?
Did you mean data throughput as in the amount of data read or written per second, or are you talking...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 15, 2012 at 11:34 am
Viewing 15 posts - 4,861 through 4,875 (of 7,164 total)