can you post the column definitions for the table and the backup script you are using to take the backup on the new server?

No, write to a new file each time with a unique name

arkiboys (11/19/2012)

---

2-I am thinking of having t he full backup of the database every...

DBCC UPDATEUSAGE, that'll be the culprit 😉

Just out of interest, does the backup\restore cross database version?

I.e. are you restoring from SQL2000 to SQL2008 for instance?

Do you have the output from...

A simple search of the Microsoft site produces this link

http://msdn.microsoft.com/en-us/library/ms151799.aspx

tinakothari (11/18/2012)

---

I want to create table and all columns. column names are database name, current date, row count, data size, index size.

in this table i want to insert about all...

ARCGIS or ARCSDE may use either an oracle or sql server RDBMS, it wouldn't be my preference to install the GIS system on the database server as these systems can...

bugg (11/18/2012)

---

What performance impact will it have on a production DB? The DB is up 24/7 with users connected at all times.

I will double check how far back the...

what was done to the database in between the restore to the secondary server and then the new backup, got any maintenance tasks\scripts running?

ah ok, to be honest i've never just sat there and watched it. Incidentally why do you have all 22 instances installed across all 5 nodes?

I usually use 256KB for data and backup drives and 64KB for log files

😉

do you have an AD Global Catalog configured on the remote site?

the stripe size specifically, the optimal stripe sizes for SQL Server are 64KB and 256KB.

As i mentioned above you need to vary your tests as data files are typically 8KB...

in that case for data and index files you'll...

you need to benchmark for a little more than 4KB sequential even for the T-log. Test for the following

8KB random read and write

4-60KB sequential write

64KB sequential read and write

up to...