Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Location
    Reading, UK
    Posts
    70

    Unanswered: DB Acess slowing Down Drastically

    hello,
    i am getting a problem

    suddenly the DB in Sql2000 has slowed down drastically
    and when i have checked the logs the error is

    Supersocket info:[spn register]:error 1355

    pls. help me

    pavan

  2. #2
    Join Date
    Aug 2002
    Posts
    20
    If you use "domain user account", to run your sql server, who does not have requisite permissions to register SPNs. You will get that message but I believe that is not the reson why your server is slow.

    How old are your statistics?

    /Mats

  3. #3
    Join Date
    May 2003
    Posts
    22
    Has anything on the network infrastructure side changed? New nics or switches? Makesure both the nic and port on the switch are configured identically. ie configure the nic for 100 full duplex and the switch port for 100 full duplex.

    I've experienced sudden performance drops when the network crew put in a new switch. The nic was configured 100 full duplex and the switch port for auto negotiate. This was a problem and was fixed by setting the switch port to 100 full duplex.


    There could be many other things which would do this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •