Derrick is correct..

SET STATISTICS TIME ON

1. run the query

2. DBCC FREEPROCCACHE ...ONLY ON DEV!

3. run the query again, this will more or less tell you how much time you...

try this first..

select cv1.chartguid

FROM cv3clientvisit AS cv1

if that works, make sure when you are doing the join the both col are the same type----ie ( varchar= varchar) not...

there could be a several issues. I would check this first.

my first guess the first time you ran it...the pages were not in cache...

you need to test this on dev...

here are the recommendation for memory settings...

http://blogs.msdn.com/b/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx

I would leave the Max setting right where you have them. For the size of Ram you have you are at the recommended setting... if you had 32 gigs of...

Toby,

please read the following...you are misunderstanding buffer cache numbers

http://www.sqlservercentral.com/blogs/a_sql_tracker/archive/2010/3/16/high-buffer-cache-hit-ratio-low-page-life-expectancy.aspx

No worries...total sql server memory is the amount sql is using. Target is the amount sql would like to have.

If total become larger then Target you will see page...

correct....I was just looking for some suggestions or work arounds!!

looks like I will have to do a backup/restore on dev and test it in 2008 mode.

Not sure of your question, Do you still have a question about context.

The # is actually about 5,000 per cpu. So it seems that you are good.

http://technet.microsoft.com/en-us/magazine/2007.10.sqlcpu.aspx

please read the following on cache hit ratio.

http://www.sqlservercentral.com/blogs/a_sql_tracker/archive/2010/3/16/high-buffer-cache-hit-ratio-low-page-life-expectancy.aspx

generally I dont look here to often. but it is good to understand it!

Please take a look at Page Life expectancy,...

if you are having troubles posting the plan please follow Gails Post

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

And as soon as you have time

PLEASE READ Grants book:-D

Ok you in the right place..so far so good.

The optimizer is cost based and SQl chooses from there. A clustered scan vs a seek based depends on your query a...

Too many DBA's

The study said about 32 DB per dba. If I took you number and dropped the Tb server and the 3 needed to support it. That would be...

FYI..I did find this study after some searching

http://www.computerworld.com/s/article/9002689/The_Total_Cost_of_Administration_Champ_Microsoft_SQL_Server_2005_or_Oracle_Database_10g_