Thanks for your replies.

I am working with code that is very old and the boss doesnt want to go back to update it.

I have limited the webuser so it can...

Thanks for you reply.

It is a non-clustered indexes.

Here is the create statement:

CREATE INDEX [Idx_SourceID] ON [dbo].[Tablename]([SourceID]) WITH FILLFACTOR = 90 ON [PRIMARY]

I'm using this statement to drop it:

drop...

Thanks to all who replied.

I move the bar over on the SQL properties page, but nothing happened.

I had to fail the cluster over to the stand by server and all...

Here's a little script I found along the way to caculate table size:

Must be ran in Steps:

--Step 1

USE hrs_backup

GO

CREATE TABLE #temp (

...

........

note that once you turn on awe dynamic memory does not work - doesn't matter what you set in memory, awe will take the amount of memory you set...

Thanks for you quick reply,

That was it, it is set to only use 15GB in the property windows.

If I change that will it effect anything? Or will it just...

The OS is 32-bit(Windows 2003 Enterprise). /PAE switch is enable. AWE is enable.

The extra memory was installed last night, but it doesn't appear that the SQL Server is...

Win,

Thanks for your reply, but it appears your solution is for a newer edition of SQL Server.

SSCrazy,

Thanks so much for your replies.

We have Memory on it's way.

I just remembered this point, we are adding lots of new webusers, the "User Connections" count went up from low...

These are the top 20 CPU usage numbers between 11am - 2pm today from the profiler.

The top 12 are the same query which I have tuned to the best of...

SSCrazy, thanks for you quick replies.

I ran you suggested query, is the CPU time accumulative? Is that why you want to take into account the login time?

Yes, it is Enterprise SQLServer 2000 version.

I want the profiler and such and nothing is standing out that points to any one server.

Our DB is over 750GB at this point....

Thanks for your quick reply.

This is going to be a WebFarm install.

Our SQL Server is intalled on Window 2003.

I guess it was doing a "Full" index, as I didnt' have a timeStamp column on the tables.

Tables get reindex every Saturday night.

Yep, it says incremental, so I'm assuming it is.