exactly.

We are going on an EMC SAN and we want the optimal cluster size/allocation unit size for SQL Server 2000 on Windows 2000 Advanced Server.

I am really concerned about...

on all Tables that is.

should the logs be on a mirrored-only drives? No striping.

Since log are sequential writes.

I've looked in BOL. Not there what I am looking for.

So for each physical read, SQL Server 2000 brings from disk to cache a 64KB chuck? (8 pages). Even...

I mean physical I/O's here.

We have recently went to an EMC SAN environment for our SQL Server 2000 development environment.

I want to start monitoring the IO's for this environment before it goes into...

wow.

So you can skip a full backup hey. I thought T-Logs were only good as far back as the last full.

Has anyone had any problems with a database after it has been upgraded from 7.0 to 2000?

(if so, solutions?)

The reason I am asking is because I am doing some performance testing.

I want how to get the size of the Buffer cache and procedure cache at any point in...

Memory in the box:

1GB + 256MB stick.

(NT 4.0, SQL Server 7.0)

This is whats happening:

1. End User creates a new Policy.

2. This gets put in a TBL_USER_ACTION table.

This is a Queue table. Could be alot of Policies queued up here.

3....

any bad experiences with Bright Stor or any other 3rd party Backup software?

any known issues with upgrading a database from 7.0 to 2000?

anybody???

Can someone explain what happens to both User and System databases when they are upgraded from 7.0 to 2000?

- what exactly are those "internal changes"?