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...

knock on wood

the unplanned downtimes we had were:

- during fire detection system tests, the backup power unit was shut down because of a little shot circuit by one of the...

sp = service pack

cu = cumulative update (intermediate hotfix bundles)

meaning the software level of your sqlserver installation.

I hope you did apply servicepacks to the installed sqlserver instance.

For SSMS,...

this is a huge NONO !

- doing so you'll create pressure on your db catalog, especially when the proc is executed in parallel !

-...

ehm ... none.

Just be sure to only provide the parameters for the client tools and only install the client tools parts you need.

Also double check to apply the sp/cu for...

oh there can be a whole world of difference between servers hosting the same database.

- do you rebuild indexes on a regular basis ?

- are the statistics up to date...

Indeed.... we live by a couple of rules, but a ton of guidelines.

JacekO (2/20/2009)

---

I guess everybody is missing my point. I even submitted a short article on this subjects few days ago and it is under review - I guess I did...

Actually the problem with that kind of like operations is that one should implement a decent split function (according to the datatype of the target column)

Then SQLServer would be able...

Grounded for the weekend 😀

well... maybe just for once ..... OK, no problem ...

Have a nice weekend :w00t: