David Burrows (10/19/2010)

---

Wow! All these negative vibes :pinch:

I come in this morning and the thread has gone serious :angry:

Now I have to find a dark room to lay down and...

Alvin Ramard (10/18/2010)

---

I'd rather it be mauve. ...

This situation is already reality for 2 years and counting 😉

other options are:

- cope with it

- wait for an occasion

- accept you can only do as much as you can....

- Start with SQLServer upgrade advisor ( http://www.microsoft.com/downloads/en/details.aspx?FamilyId=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852&displaylang=en )

- prepare for security impact, try to optimize service account setup and implement best practises.

- 64-bit is only a other version of...

HowardW (10/15/2010)

---

ALZDBA (10/15/2010)

---

btw not so long ago, I had a bird strike whilest riding my bike. It hit me on top of my helmet, right above the vizor. It was...

WayneS (10/16/2010)

---

I just read through this thread, and what I found interesting was what was missing (or, I just failed to see it...)

The keys in a clustered index are used...

did you check your firewall is open for this port number ?

By default, sqlserver will fill pages to 100%.

You can change this default behaviour using sp_configure 'fill factor', ...

This is an advanced setting.

ref: http://msdn.microsoft.com/en-us/library/aa196711%28SQL.80%29.aspx

If you have the space available, and 85%...

ss-457805 (10/16/2010)

---

Correction: you're doing 4 PK clustered index scans (aka table scan) on the LEISTUNGSPREISE table, each time on a different column (KONTO_BUCH, KONTO_STEUER_PROV, KONTO_PROV and KONTO_STEUER_VK). It seems that...

Predictability can be an issue when using a uniqueidentifier for clustering key.

They (ms) provided the new "new sequential id" to help with that, so when you start inserting a bunch...

- Did you run the upgrade advisor ?

- do you run dbcc checkdb on a regular basis, so you know your dbs pages are in good shape.

- did you run...

It is a good thing you posted the sqlplan :w00t:

Did you notice you are hitting 31 objects with this simple delete statement ?

Table [LEISTUNGSPREISE] is accessed using a clustered...

Still fixing problems, although I did warn the teams for the consequences of their decisions and their neglecting the advises dba have handed to them.

This fixing is to the advantage...

Kind of like "I heard a brake noise ... now my dog is limping ... Why?"

Please post the ddl of your table and all of the current constraints (including FKs).

Also...

can you provide a bit of input.

- can you find any info in your sqlserver errorlog file(s) ?

- how did you set up your mirroring (ddl please)

- what kind of...