How do you mean paging file values? Page file is currently set to 20GB (a bit overkill but wasn't setup by myself) and the max ever used is about 3gb.

The...

sql server does not have priority:

from http://support.microsoft.com/kb/319942:

IMPORTANT Do not use priority boost for clustered servers that are running SQL Server 7.0, SQL Server 2000, or SQL Server 2005.

Buffer cache hit...

anyone??

has anyone on here had any experience of SAN replication?

what i'd like to have is 2 sites, each with its own load balanced (active/active) clustered environment and SAN (FC...

as far as i'm aware you can't disable a windows group login, individual yes but not groups....

this could be due to the fact that the columns involved in these indexes are not amended...

Yes i agree but the original server build image was for servers which didn't need IIS installed and therefore when a server which later needs IIS installed then it was...

decided i'd put my solution onto this seeing as I started it many moons ago 😀

My original issue was never fully solved, i ended up running reporting services from a...

sqlio.exe

Cheers for that,

2) Please refer to my original post, whoever set our san up originally (before my time - believe it to be DELL themselves) created 4 RAID groups with...

Hi, thanks for the response.

1) Will putting the tlogs on the raid10 be still as quick even though there are numerous log and data files on there? Can i...

anyone??

that's the problem, they are seperate in the fact they're seperate physical dbs, but in actual fact they all refer to each other as part of one application but there...

Anyone?

EdVassie (3/9/2007)

You can create a database on Dev or EEedition and set up partitioning. Take a backup of the database and restore it to Standard Edition, and it should work...