in actual fact I suspect what you're trying to avoid may be the best method . e.g. less complexity. I seem to remember there were a bunch of commands...

in the sense of conventional cpu you cannot breakdown the 90% into %age per database. cpu is stored as ticks or cycles. Technically you could track back the processid...

I had to smile reading your post - stopping devs changing things!! An extremely good practice to my mind.

Anyway CDC and replication are totally different and I can't really see...

have a read up on this info from SQL Cat team ( on my website )

http://www.grumpyolddba.co.uk/monitoring/Performance%20Counter%20Guidance%20-%20SQL%20Server.htm

I guess this comes from some kind of monitoring tool?

Most tools attempt to set a threshold , locks is not an easy one to set, for instance I see...

Gail's right concerning space, however there's a lot of views that if most of your io occurs in cache then fragmentation on disk doesn't make any difference, especially as in...

yup working with msdb is a bit of a black art at times. Can't think the number of times I've thought " why on earth did they do that?" I...

It's a tricky one when you have all on one server - gets even more muddy when you're generating stuff from Sharepoint.

I'd take the original post to be a...

this is what I use

--

-- Server buffer Cache

--

select isnull(db_name(database_id),'Total') as 'Database Name',

convert(numeric(8,2),count(page_id)/128.0) as Mb

from sys.dm_os_buffer_descriptors with (nolock)

where database_id !=32767

group by database_id

with rollup

order by count(page_id) desc;

It's really difficult to answer this because I think it's a case of what suits your system. I run a sp_updatestats with resample every night at a quiet time, I...

well you've introduced the two biggest performance bottlenecks known to man for SQL Server 😀

I hate virtualised SQL Server and in tests I was able to outperform a very expensive...

oh yes the "times" - back in sql 2000 I wrote some functions which convert the times into something usable.

USE [msdb]

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id...

tricky, the problem with "long running" is define what is actually long running, it sort of means you've got to compare back to previous runs to decide if the...

no worries - it can be tricky sometimes, I seem to remember one sp which had so many file options and it took me three tries to get the right...

As one who would happily describe themselves as well capable of being "snarky", a word I've not heard before, it's not about what might be defined as "dumb" because...