Duplicate Indentity Values in Primary Key Column

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

  • 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]

  •  Bay 1Bay 2Bay 3Bay 4Bay 5Bay 6Bay 7Bay 8Bay 9Bay 10Bay 11Bay 12Bay 13Bay 14ArrayCapacity MBServerLocal disk
    Box 1ABBBADCDD(A?)EFFFA700068HW41D
    Box 2ABDGADDCA(C?)EFFFB69463HW4H
    Box 3CCCAAAAA(A?)(C?)(A(s)?)B(s)(C(s)?)D(s)C104195HW41X
    D140010HW41F
    E420035HW5F
    F420041HW40F
        

    Server HW4 was the one in Question

  • Thanks!

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

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

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