you don't have enough memory and if you enable the /3gb switch all instances will share the 3gb vas. I think there may be some confusion over the bottom...

Most important don't compare x64 and x32 sql server. The awe tick box remains in x64 but it does absolutely nothing, at all, ever, ever.

x32 - 4gb...

so do you watch old posts in your spare time

yeah right - no easy answer to this. You should trend/baseline your existing server/databases. Establish a time for doing certain things, even if it's a checkdb or a full index...

actually sometimes the quickest way to defrag a mdf file is to detach the database and copy the file to another drive and back. In fact I just had this...

I'm assuming that we all defrag our PC's on a regular basis and that we genrally see an improvement if we do so?

Same for servers.

It's the actual file which fragments,...

try looking at http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/01/24/perfmon-counters-thresholds.aspx

I'd also recommend the book SQL Server 2000 performance tuning reference manual

actually using a san for storage is fine - set up correctly you can at least eliminate single point of failure routes to your data and management is good. FC...

Ah but if you size your files so growth is rare - once you've defragged they'll stay that way - you only have gaps if the drive is fragmented.

well I've successfully replicated sql 2000 databases to sql 2005, subject to the conditions and restrictions of transactional replication.

So answer yup you could do what you want to do.

after...

Not to be done whilst the database is busy but you can use the w2k3 defrag with sql server on-line, been doing this since around 2003!

Like any such...

Actually i was just thinking that each time a thread gets going on storage and SANs it really generates a lot of interest making me more than certain that storage...

note that you can attach fc DAS, fc isn't only the domain of the network.

Yes! Standard reports will show disk usage by file. Right click on the database and examine std reports.

Shrinking files, especially databases isn't good practice - you'll...

the usual cause would be that the sql accounts do not have sufficient permissions to do what you're asking.