What's the number of rows that match the criteria ?

Is that number the same for both instances ?

How about concurrency ?

What software level are you on (@@version) ?

- Is there a clustering index on that table ?

if not, provide one, unless you can prove it hurts performance.

Data pages may be scattered all over...

the script also works on SP2.

By now you should at least be on SP2 with CU2 and if you can directly go to SP3.

MS did improve the product to your...

Oh yes ... SANs .... the big black magic box :hehe:

- Performance monitoring a SAN is very vendor specific, so contact your vendor if you really think that is the...

You pull over the data to be processed into a temptb, so you'll no longer lock out the actual table.

- Why don't you use a regular cursor to loop your...

- size

- distribution

- index organization

- memory usage

- paging activity

- other processes on the server

- locking

Get things organized !

create table Testperf (col1 varchar(5000) )

cannot be a reference because of ... table design.

No indexes, a table with a single column, ...

If you want to stress test...

Mark Pratt (2/24/2009)

---

The command in question looks like this -

EXEC MASTER..xp_cmdshell 'BCP "EXEC GfmReplication.dbo.zz_ExportXml" queryout c:\Org.xml -S(local) -T -c'

The problem is that my script, being part of a unit...

If there is no ETL in between your prod to DR instance, check if your backup actually completed successfully.

Also check your backup set contains only one backup instance, otherwise you...

you would be better off using a separate step in the job and use sqlcmd to export the data or use TSQL backup to create a full db backup.

- does...

- you need to revise your application !

- you can elevate sqlservers sensitivity to deadlock detection and intervention using sp_configure "blocked process threshold "

- activate trace 1222 to get an...

imo that view must have been created / altered after your backup started or ended.

Some of us create a full backup and make additional log backup(s) afterward to be restored...

- which activity monitor are you refering to ? (profiler/perfmon/..)

- are you trying to sample connections or do you want an actual sqlserver usage report (queries etc.)

In that...

do you want an overhaul or a new car ?

automated deployment ... as in unattended deployment ... on a cluster ?

Lovely to see this behaviour :sick:

Another reason we still perform the upgrades with (requested) planned downtime and under strickt...