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
pavanIf 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|||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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment