also try http://www.jumpstarttv.com/clustering-sql-server-2005_33.aspx, brian knight has 3 good videos there that will give you a good overview.

good luck

I am doing a few things.

I first open the perf mon and watch the graph in real time.

Then during that same time period I run profiler and permon trace. with...

also check out Brian knight ---http://www.jumpstarttv.com/Search.aspx?terms=cluster

he has 3 videos there that will get you started...good luck

FANTASTIC.......I should be able to fill the temp table with a qry and I am off and running

😀

hi there check out slava,s blog -- http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx

Max worker threads setting does affect how much memory server will require under heavy concurrent load. Consider on x64 platform each SQL Server...

Hi Elisabeth,

thanks that clear up more then I have found so far. I am running 64 bit server and sql 2005 which is set at default.

I believe I got...

Just in case anyone runs into this problem uninstall IIS.Then go to Sql Mail and delete the profile and account, make sure it is completed deleted. Restart SQL server agent...

just a heads up and my already know if you do not elect to add a UNIQUE NON CLUSTERED constraint

SQL will elect to one on its own in the...

SWEET lots of help!!!

here is the answer in case it helps anyone

WITH DirAgent(AccountID, date) AS

(

select AccountID, substring(CAST(DATE AS varchar(30)),1,3)as date

from account_log

where productid = 100870 and

date > 12/31/2006

group...

good catch....thanks.

I took this server over a few days ago, had not had a chance to check everything as of yes

2 cpu -- 2 cores ---so 4

no cluster

windows 2003 64 bit sp1 standard edition

The reading I did last night said awe does not work on 64 bit? same as locking...

my buffer is is in the high 90% but and in the past I always read that 98-99 then there was not a problem. as far as memory.

but after so...

I am still not sure on this ?

Total server memory -- 1,900,568 -- this is telling me that roughly 3 gigs is being used or this telling me...

yes SQL 64 bit and 64 bit 2003 windows server OS....so I am unable to make any changes as far as awe and page locking...

sounds like I need to add...