Duplicate Indentity Values in Primary Key Column

Question

Duplicate Indentity Values in Primary Key Column

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

prn9974 SSCrazy Points: 2000 More actions · Answer 1

Thanks everyone & Sorry for such a long delay...

Cause found: It was improper set up of the SANS. We used the Microsoft's SQLIOStress utility to check the SANS sanity. Once we resolved the SANS configuration issues, the problems disappeared.

Apparently the buffer was messedup and the SQL Server was not properly seeing the identity value. As to why duplicate value was inserted in a Primary Key column is not explained properly. But they all related to the SANS.

Thanks everyone.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

Thanks for posting the results. Good to see it is finally solved somehow.

Would you mind posting some of your SAN specs?

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

prn9974 SSCrazy Points: 2000 More actions · Answer 3

Bay 1

Bay 2

Bay 3

Bay 4

Bay 5

Bay 6

Bay 7

Bay 8

Bay 9

Bay 10

Bay 11

Bay 12

Bay 13

Bay 14

Array

Capacity MB

Server

Local disk

Box 1

A

B

A

D

C

D

(A?)

E

F

A

700068

HW41

D

Box 2

A

B

D

G

A

D

C

A

(C?)

E

F

B

69463

HW4

H

Box 3

C

A

(A?)

(C?)

(A(s)?)

B(s)

(C(s)?)

D(s)

C

104195

HW41

X

D

140010

HW41

F

E

420035

HW5

F

420041

HW40

F

Server HW4 was the one in Question

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

Thanks!

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]