SQL Server 2000 Performance problems

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Server 2000 Performance problems

Author

Topic

roykauf
Starting Member

36 Posts

Posted - 2008-09-29 : 09:15:15

I am facing a big problem the last 3 days. the SQL is slow and I get these messages at the current activity log:

error: 15457, severity:0, state:1

the previous messages are:

Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.

Using 'odsole70.dll' version '2000.80.760' to execute extended stored procedure 'sp_OACreate'.

Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..

Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_msver'.

PLease help me. I don't know what to do .
The server is 2000 server + sp4

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-29 : 09:38:34

quote:
Originally posted by roykauf

I am facing a big problem the last 3 days. the SQL is slow and I get these messages at the current activity log:

error: 15457, severity:0, state:1

the previous messages are:

Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.

Using 'odsole70.dll' version '2000.80.760' to execute extended stored procedure 'sp_OACreate'.

Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..

Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_msver'.

PLease help me. I don't know what to do .
The server is 2000 server + sp4

That is normal behavior.What do you see slow...Server??? or SQL query?

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-09-29 : 10:12:25

quote:
Originally posted by roykauf

I am facing a big problem the last 3 days. the SQL is slow and I get these messages at the current activity log:

error: 15457, severity:0, state:1

the previous messages are:

Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.

Using 'odsole70.dll' version '2000.80.760' to execute extended stored procedure 'sp_OACreate'.

Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..

Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_msver'.

PLease help me. I don't know what to do .
The server is 2000 server + sp4

Run RECONFIGURE when your serverwide configuration options have changed and needs 2b updated

roykauf
Starting Member

36 Posts

Posted - 2008-09-29 : 10:14:06

I have also thie message on windows event viewer:
EVENT ID 19011 Source: MSSQLServer
SuperSocket info: (SpnRegister) : Error 1355. . any thing?

roykauf
Starting Member

36 Posts

Posted - 2008-09-29 : 10:33:46

and will it help to solve these problems?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources