Hi All
Can anybody tell me why Memory is not utilized by MSSQL Service. The Environment as follows..
It is an Critical Web based Application with SQL 2000 Standard Edition + SP3 as backend
OS: Win 2000 Advanced Server + 3GB Memory + 2 CP
MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2 GB". This Server has Replication
Configuration also. During peak time or non-peak time, it always use 1 GB Memory only. Why MSSQL is not taking more than 1 GB, even though server has got 3 GB and database's max. memory configured as 2 GB
In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we will give /3GB in boot.ini. Similarly anything should be given for SQL 2000 Standard Edition. Right now, boot.ini doesn't contain this option
Appreciate your help on this
tks in advance
vasuAre you running other applications on the server besides SQL Server? SQL
Server will manage memory based on amount of free memory available.
Consequently, if other apps running on the same box (e.g. IIS) consume
significant amounts of memory, SQL Server won't acquire additional memory
because this would negatively impact performance.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>|||Verify if your application is I/O bound or Memory Bound '
If your cpu utilization is fixed at 100%, then you should worry about
Memory.
Most of the performance problems in databases usually come from locks,
blocking, lot of IO read/writes, etc.
Check http://www.sql-server-performance.com/ for various ways to measure SQL
Server Performance.
Amol.
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>
Showing posts with label edition. Show all posts
Showing posts with label edition. Show all posts
Friday, March 30, 2012
MSSQL 2000 Standard Edition not utilizing Maximum Memory!
Hi All,
Can anybody tell me why Memory is not utilized by MSSQL Service. The Environment as follows...
It is an Critical Web based Application with SQL 2000 Standard Edition + SP3 as backend .
OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2 GB". This Server has Replication
Configuration also. During peak time or non-peak time, it always use 1 GB Memory only. Why MSSQL is not taking more than 1 GB, even though server has got 3 GB and database's max. memory configured as 2 GB.
In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we will give /3GB in boot.ini. Similarly anything should be given for SQL 2000 Standard Edition. Right now, boot.ini doesn't contain this option.
Appreciate your help on this.
tks in advance,
vasum
Are you running other applications on the server besides SQL Server? SQL
Server will manage memory based on amount of free memory available.
Consequently, if other apps running on the same box (e.g. IIS) consume
significant amounts of memory, SQL Server won't acquire additional memory
because this would negatively impact performance.
Hope this helps.
Dan Guzman
SQL Server MVP
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>
|||Verify if your application is I/O bound or Memory Bound ?
If your cpu utilization is fixed at 100%, then you should worry about
Memory.
Most of the performance problems in databases usually come from locks,
blocking, lot of IO read/writes, etc.
Check http://www.sql-server-performance.com/ for various ways to measure SQL
Server Performance.
Amol.
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>
Can anybody tell me why Memory is not utilized by MSSQL Service. The Environment as follows...
It is an Critical Web based Application with SQL 2000 Standard Edition + SP3 as backend .
OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2 GB". This Server has Replication
Configuration also. During peak time or non-peak time, it always use 1 GB Memory only. Why MSSQL is not taking more than 1 GB, even though server has got 3 GB and database's max. memory configured as 2 GB.
In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we will give /3GB in boot.ini. Similarly anything should be given for SQL 2000 Standard Edition. Right now, boot.ini doesn't contain this option.
Appreciate your help on this.
tks in advance,
vasum
Are you running other applications on the server besides SQL Server? SQL
Server will manage memory based on amount of free memory available.
Consequently, if other apps running on the same box (e.g. IIS) consume
significant amounts of memory, SQL Server won't acquire additional memory
because this would negatively impact performance.
Hope this helps.
Dan Guzman
SQL Server MVP
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>
|||Verify if your application is I/O bound or Memory Bound ?
If your cpu utilization is fixed at 100%, then you should worry about
Memory.
Most of the performance problems in databases usually come from locks,
blocking, lot of IO read/writes, etc.
Check http://www.sql-server-performance.com/ for various ways to measure SQL
Server Performance.
Amol.
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>
MSSQL 2000 Standard Edition not utilizing Maximum Memory!
Hi All,
Can anybody tell me why Memory is not utilized by MSSQL Service. The Environ
ment as follows...
It is an Critical Web based Application with SQL 2000 Standard Edition + SP3
as backend .
OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2 GB
". This Server has Replication
Configuration also. During peak time or non-peak time, it always use 1 GB Me
mory only. Why MSSQL is not taking more than 1 GB, even though server has go
t 3 GB and database's max. memory configured as 2 GB.
In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we w
ill give /3GB in boot.ini. Similarly anything should be given for SQL 2000 S
tandard Edition. Right now, boot.ini doesn't contain this option.
Appreciate your help on this.
tks in advance,
vasumAre you running other applications on the server besides SQL Server? SQL
Server will manage memory based on amount of free memory available.
Consequently, if other apps running on the same box (e.g. IIS) consume
significant amounts of memory, SQL Server won't acquire additional memory
because this would negatively impact performance.
Hope this helps.
Dan Guzman
SQL Server MVP
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>|||Verify if your application is I/O bound or Memory Bound '
If your cpu utilization is fixed at 100%, then you should worry about
Memory.
Most of the performance problems in databases usually come from locks,
blocking, lot of IO read/writes, etc.
Check http://www.sql-server-performance.com/ for various ways to measure SQL
Server Performance.
Amol.
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>
Can anybody tell me why Memory is not utilized by MSSQL Service. The Environ
ment as follows...
It is an Critical Web based Application with SQL 2000 Standard Edition + SP3
as backend .
OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2 GB
". This Server has Replication
Configuration also. During peak time or non-peak time, it always use 1 GB Me
mory only. Why MSSQL is not taking more than 1 GB, even though server has go
t 3 GB and database's max. memory configured as 2 GB.
In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we w
ill give /3GB in boot.ini. Similarly anything should be given for SQL 2000 S
tandard Edition. Right now, boot.ini doesn't contain this option.
Appreciate your help on this.
tks in advance,
vasumAre you running other applications on the server besides SQL Server? SQL
Server will manage memory based on amount of free memory available.
Consequently, if other apps running on the same box (e.g. IIS) consume
significant amounts of memory, SQL Server won't acquire additional memory
because this would negatively impact performance.
Hope this helps.
Dan Guzman
SQL Server MVP
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>|||Verify if your application is I/O bound or Memory Bound '
If your cpu utilization is fixed at 100%, then you should worry about
Memory.
Most of the performance problems in databases usually come from locks,
blocking, lot of IO read/writes, etc.
Check http://www.sql-server-performance.com/ for various ways to measure SQL
Server Performance.
Amol.
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>
MSSQL 2000 Developer Edition limit of connection ?
J.H wrote:
> Dear All,
> I've been searching the MSDN web for the MSSQL 2000 Developer connection
> limit.
> However, could not find any authentic documentation that says MSSQL 2000
> Developer
> connection information.
> With MSSQL 2000 Developer Edition, do we have any limitation of connection
> direct to
> database? We do have user connecting to this database through http/asp, an
d
> plus user connecting direct to database by 1433. However those users conne
ct
> direct to database by
> 1433 getting low performance, slow, sometimes got disconnection from the
> MSSQL 2000
> Developer Edition that we have.
> Our server is single Xeon enabled hyperthreading 2 logical map to 1 physic
al
> (this is another
> factor for slow performance), this server has MSSQL 2000 Developer Edition
> installed.
> Thanks for any input,
> JH
There is no connection limit specific to Dev Edition.
Make sure that you enable only 1 logical processor per physical
processor in SQL Server.
Note that Developer Edition is licensed for development and testing use
only.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--Hi David,
Is there any explaination why it is fast on clients that access from
HTTP/ASAP page and
slown performance/disconnection on client accessig database through ODBC
1433?
Thanks for any input,
JH
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1150828951.963023.188820@.g10g2000cwb.googlegroups.com...
> J.H wrote:
connection[vbcol=seagreen]
and[vbcol=seagreen]
connect[vbcol=seagreen]
physical[vbcol=seagreen]
Edition[vbcol=seagreen]
> There is no connection limit specific to Dev Edition.
> Make sure that you enable only 1 logical processor per physical
> processor in SQL Server.
> Note that Developer Edition is licensed for development and testing use
> only.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>|||Dear All,
I've been searching the MSDN web for the MSSQL 2000 Developer connection
limit.
However, could not find any authentic documentation that says MSSQL 2000
Developer
connection information.
With MSSQL 2000 Developer Edition, do we have any limitation of connection
direct to
database? We do have user connecting to this database through http/asp, and
plus user connecting direct to database by 1433. However those users connect
direct to database by
1433 getting low performance, slow, sometimes got disconnection from the
MSSQL 2000
Developer Edition that we have.
Our server is single Xeon enabled hyperthreading 2 logical map to 1 physical
(this is another
factor for slow performance), this server has MSSQL 2000 Developer Edition
installed.
Thanks for any input,
JH|||J.H wrote:
> Dear All,
> I've been searching the MSDN web for the MSSQL 2000 Developer connection
> limit.
> However, could not find any authentic documentation that says MSSQL 2000
> Developer
> connection information.
> With MSSQL 2000 Developer Edition, do we have any limitation of connection
> direct to
> database? We do have user connecting to this database through http/asp, an
d
> plus user connecting direct to database by 1433. However those users conne
ct
> direct to database by
> 1433 getting low performance, slow, sometimes got disconnection from the
> MSSQL 2000
> Developer Edition that we have.
> Our server is single Xeon enabled hyperthreading 2 logical map to 1 physic
al
> (this is another
> factor for slow performance), this server has MSSQL 2000 Developer Edition
> installed.
> Thanks for any input,
> JH
There is no connection limit specific to Dev Edition.
Make sure that you enable only 1 logical processor per physical
processor in SQL Server.
Note that Developer Edition is licensed for development and testing use
only.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi David,
Is there any explaination why it is fast on clients that access from
HTTP/ASAP page and
slown performance/disconnection on client accessig database through ODBC
1433?
Thanks for any input,
JH
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1150828951.963023.188820@.g10g2000cwb.googlegroups.com...
> J.H wrote:
connection[vbcol=seagreen]
and[vbcol=seagreen]
connect[vbcol=seagreen]
physical[vbcol=seagreen]
Edition[vbcol=seagreen]
> There is no connection limit specific to Dev Edition.
> Make sure that you enable only 1 logical processor per physical
> processor in SQL Server.
> Note that Developer Edition is licensed for development and testing use
> only.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>
> Dear All,
> I've been searching the MSDN web for the MSSQL 2000 Developer connection
> limit.
> However, could not find any authentic documentation that says MSSQL 2000
> Developer
> connection information.
> With MSSQL 2000 Developer Edition, do we have any limitation of connection
> direct to
> database? We do have user connecting to this database through http/asp, an
d
> plus user connecting direct to database by 1433. However those users conne
ct
> direct to database by
> 1433 getting low performance, slow, sometimes got disconnection from the
> MSSQL 2000
> Developer Edition that we have.
> Our server is single Xeon enabled hyperthreading 2 logical map to 1 physic
al
> (this is another
> factor for slow performance), this server has MSSQL 2000 Developer Edition
> installed.
> Thanks for any input,
> JH
There is no connection limit specific to Dev Edition.
Make sure that you enable only 1 logical processor per physical
processor in SQL Server.
Note that Developer Edition is licensed for development and testing use
only.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--Hi David,
Is there any explaination why it is fast on clients that access from
HTTP/ASAP page and
slown performance/disconnection on client accessig database through ODBC
1433?
Thanks for any input,
JH
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1150828951.963023.188820@.g10g2000cwb.googlegroups.com...
> J.H wrote:
connection[vbcol=seagreen]
and[vbcol=seagreen]
connect[vbcol=seagreen]
physical[vbcol=seagreen]
Edition[vbcol=seagreen]
> There is no connection limit specific to Dev Edition.
> Make sure that you enable only 1 logical processor per physical
> processor in SQL Server.
> Note that Developer Edition is licensed for development and testing use
> only.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>|||Dear All,
I've been searching the MSDN web for the MSSQL 2000 Developer connection
limit.
However, could not find any authentic documentation that says MSSQL 2000
Developer
connection information.
With MSSQL 2000 Developer Edition, do we have any limitation of connection
direct to
database? We do have user connecting to this database through http/asp, and
plus user connecting direct to database by 1433. However those users connect
direct to database by
1433 getting low performance, slow, sometimes got disconnection from the
MSSQL 2000
Developer Edition that we have.
Our server is single Xeon enabled hyperthreading 2 logical map to 1 physical
(this is another
factor for slow performance), this server has MSSQL 2000 Developer Edition
installed.
Thanks for any input,
JH|||J.H wrote:
> Dear All,
> I've been searching the MSDN web for the MSSQL 2000 Developer connection
> limit.
> However, could not find any authentic documentation that says MSSQL 2000
> Developer
> connection information.
> With MSSQL 2000 Developer Edition, do we have any limitation of connection
> direct to
> database? We do have user connecting to this database through http/asp, an
d
> plus user connecting direct to database by 1433. However those users conne
ct
> direct to database by
> 1433 getting low performance, slow, sometimes got disconnection from the
> MSSQL 2000
> Developer Edition that we have.
> Our server is single Xeon enabled hyperthreading 2 logical map to 1 physic
al
> (this is another
> factor for slow performance), this server has MSSQL 2000 Developer Edition
> installed.
> Thanks for any input,
> JH
There is no connection limit specific to Dev Edition.
Make sure that you enable only 1 logical processor per physical
processor in SQL Server.
Note that Developer Edition is licensed for development and testing use
only.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi David,
Is there any explaination why it is fast on clients that access from
HTTP/ASAP page and
slown performance/disconnection on client accessig database through ODBC
1433?
Thanks for any input,
JH
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1150828951.963023.188820@.g10g2000cwb.googlegroups.com...
> J.H wrote:
connection[vbcol=seagreen]
and[vbcol=seagreen]
connect[vbcol=seagreen]
physical[vbcol=seagreen]
Edition[vbcol=seagreen]
> There is no connection limit specific to Dev Edition.
> Make sure that you enable only 1 logical processor per physical
> processor in SQL Server.
> Note that Developer Edition is licensed for development and testing use
> only.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>
MSSQL 2000 Developer Edition limit of connection ?
Dear All,
I've been searching the MSDN web for the MSSQL 2000 Developer connection
limit.
However, could not find any authentic documentation that says MSSQL 2000
Developer
connection information.
With MSSQL 2000 Developer Edition, do we have any limitation of connection
direct to
database? We do have user connecting to this database through http/asp, and
plus user connecting direct to database by 1433. However those users connect
direct to database by
1433 getting low performance, slow, sometimes got disconnection from the
MSSQL 2000
Developer Edition that we have.
Our server is single Xeon enabled hyperthreading 2 logical map to 1 physical
(this is another
factor for slow performance), this server has MSSQL 2000 Developer Edition
installed.
Thanks for any input,
JHJ.H wrote:
> Dear All,
> I've been searching the MSDN web for the MSSQL 2000 Developer connection
> limit.
> However, could not find any authentic documentation that says MSSQL 2000
> Developer
> connection information.
> With MSSQL 2000 Developer Edition, do we have any limitation of connection
> direct to
> database? We do have user connecting to this database through http/asp, and
> plus user connecting direct to database by 1433. However those users connect
> direct to database by
> 1433 getting low performance, slow, sometimes got disconnection from the
> MSSQL 2000
> Developer Edition that we have.
> Our server is single Xeon enabled hyperthreading 2 logical map to 1 physical
> (this is another
> factor for slow performance), this server has MSSQL 2000 Developer Edition
> installed.
> Thanks for any input,
> JH
There is no connection limit specific to Dev Edition.
Make sure that you enable only 1 logical processor per physical
processor in SQL Server.
Note that Developer Edition is licensed for development and testing use
only.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi David,
Is there any explaination why it is fast on clients that access from
HTTP/ASAP page and
slown performance/disconnection on client accessig database through ODBC
1433?
Thanks for any input,
JH
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1150828951.963023.188820@.g10g2000cwb.googlegroups.com...
> J.H wrote:
> > Dear All,
> >
> > I've been searching the MSDN web for the MSSQL 2000 Developer connection
> > limit.
> > However, could not find any authentic documentation that says MSSQL 2000
> > Developer
> > connection information.
> >
> > With MSSQL 2000 Developer Edition, do we have any limitation of
connection
> > direct to
> > database? We do have user connecting to this database through http/asp,
and
> > plus user connecting direct to database by 1433. However those users
connect
> > direct to database by
> > 1433 getting low performance, slow, sometimes got disconnection from the
> > MSSQL 2000
> > Developer Edition that we have.
> >
> > Our server is single Xeon enabled hyperthreading 2 logical map to 1
physical
> > (this is another
> > factor for slow performance), this server has MSSQL 2000 Developer
Edition
> > installed.
> >
> > Thanks for any input,
> > JH
> There is no connection limit specific to Dev Edition.
> Make sure that you enable only 1 logical processor per physical
> processor in SQL Server.
> Note that Developer Edition is licensed for development and testing use
> only.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>
I've been searching the MSDN web for the MSSQL 2000 Developer connection
limit.
However, could not find any authentic documentation that says MSSQL 2000
Developer
connection information.
With MSSQL 2000 Developer Edition, do we have any limitation of connection
direct to
database? We do have user connecting to this database through http/asp, and
plus user connecting direct to database by 1433. However those users connect
direct to database by
1433 getting low performance, slow, sometimes got disconnection from the
MSSQL 2000
Developer Edition that we have.
Our server is single Xeon enabled hyperthreading 2 logical map to 1 physical
(this is another
factor for slow performance), this server has MSSQL 2000 Developer Edition
installed.
Thanks for any input,
JHJ.H wrote:
> Dear All,
> I've been searching the MSDN web for the MSSQL 2000 Developer connection
> limit.
> However, could not find any authentic documentation that says MSSQL 2000
> Developer
> connection information.
> With MSSQL 2000 Developer Edition, do we have any limitation of connection
> direct to
> database? We do have user connecting to this database through http/asp, and
> plus user connecting direct to database by 1433. However those users connect
> direct to database by
> 1433 getting low performance, slow, sometimes got disconnection from the
> MSSQL 2000
> Developer Edition that we have.
> Our server is single Xeon enabled hyperthreading 2 logical map to 1 physical
> (this is another
> factor for slow performance), this server has MSSQL 2000 Developer Edition
> installed.
> Thanks for any input,
> JH
There is no connection limit specific to Dev Edition.
Make sure that you enable only 1 logical processor per physical
processor in SQL Server.
Note that Developer Edition is licensed for development and testing use
only.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi David,
Is there any explaination why it is fast on clients that access from
HTTP/ASAP page and
slown performance/disconnection on client accessig database through ODBC
1433?
Thanks for any input,
JH
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1150828951.963023.188820@.g10g2000cwb.googlegroups.com...
> J.H wrote:
> > Dear All,
> >
> > I've been searching the MSDN web for the MSSQL 2000 Developer connection
> > limit.
> > However, could not find any authentic documentation that says MSSQL 2000
> > Developer
> > connection information.
> >
> > With MSSQL 2000 Developer Edition, do we have any limitation of
connection
> > direct to
> > database? We do have user connecting to this database through http/asp,
and
> > plus user connecting direct to database by 1433. However those users
connect
> > direct to database by
> > 1433 getting low performance, slow, sometimes got disconnection from the
> > MSSQL 2000
> > Developer Edition that we have.
> >
> > Our server is single Xeon enabled hyperthreading 2 logical map to 1
physical
> > (this is another
> > factor for slow performance), this server has MSSQL 2000 Developer
Edition
> > installed.
> >
> > Thanks for any input,
> > JH
> There is no connection limit specific to Dev Edition.
> Make sure that you enable only 1 logical processor per physical
> processor in SQL Server.
> Note that Developer Edition is licensed for development and testing use
> only.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>
Monday, March 26, 2012
MSRS Developer Edition on MS SQL 2000 STD
Hello,
I have a client installation I need to load Reporting Services on but
the disk they put into the server is Developer edition rather than
standard. This is a production server. Are their any potential issues I
might encounter?
Any information is greatly appreciated.
Thanks,
HLittle things like licensing issues a concern?
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1164072012.870727.39050@.m73g2000cwd.googlegroups.com...
> Hello,
> I have a client installation I need to load Reporting Services on but
> the disk they put into the server is Developer edition rather than
> standard. This is a production server. Are their any potential issues I
> might encounter?
> Any information is greatly appreciated.
> Thanks,
> H
>
I have a client installation I need to load Reporting Services on but
the disk they put into the server is Developer edition rather than
standard. This is a production server. Are their any potential issues I
might encounter?
Any information is greatly appreciated.
Thanks,
HLittle things like licensing issues a concern?
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1164072012.870727.39050@.m73g2000cwd.googlegroups.com...
> Hello,
> I have a client installation I need to load Reporting Services on but
> the disk they put into the server is Developer edition rather than
> standard. This is a production server. Are their any potential issues I
> might encounter?
> Any information is greatly appreciated.
> Thanks,
> H
>
MSRS Developer Edition on MS SQL 2000 STD
Hello,
I have a client installation I need to load Reporting Services on but
the disk they put into the server is Developer edition rather than
standard. This is a production server. Are their any potential issues I
might encounter?
Any information is greatly appreciated.
Thanks,
H
Little things like licensing issues a concern?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1164072012.870727.39050@.m73g2000cwd.googlegro ups.com...
> Hello,
> I have a client installation I need to load Reporting Services on but
> the disk they put into the server is Developer edition rather than
> standard. This is a production server. Are their any potential issues I
> might encounter?
> Any information is greatly appreciated.
> Thanks,
> H
>
I have a client installation I need to load Reporting Services on but
the disk they put into the server is Developer edition rather than
standard. This is a production server. Are their any potential issues I
might encounter?
Any information is greatly appreciated.
Thanks,
H
Little things like licensing issues a concern?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1164072012.870727.39050@.m73g2000cwd.googlegro ups.com...
> Hello,
> I have a client installation I need to load Reporting Services on but
> the disk they put into the server is Developer edition rather than
> standard. This is a production server. Are their any potential issues I
> might encounter?
> Any information is greatly appreciated.
> Thanks,
> H
>
MSRS Developer Edition on MS SQL 2000 STD
Hello,
I have a client installation I need to load Reporting Services on but
the disk they put into the server is Developer edition rather than
standard. This is a production server. Are their any potential issues I
might encounter?
Any information is greatly appreciated.
Thanks,
HLittle things like licensing issues a concern?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1164072012.870727.39050@.m73g2000cwd.googlegroups.com...
> Hello,
> I have a client installation I need to load Reporting Services on but
> the disk they put into the server is Developer edition rather than
> standard. This is a production server. Are their any potential issues I
> might encounter?
> Any information is greatly appreciated.
> Thanks,
> H
>
I have a client installation I need to load Reporting Services on but
the disk they put into the server is Developer edition rather than
standard. This is a production server. Are their any potential issues I
might encounter?
Any information is greatly appreciated.
Thanks,
HLittle things like licensing issues a concern?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1164072012.870727.39050@.m73g2000cwd.googlegroups.com...
> Hello,
> I have a client installation I need to load Reporting Services on but
> the disk they put into the server is Developer edition rather than
> standard. This is a production server. Are their any potential issues I
> might encounter?
> Any information is greatly appreciated.
> Thanks,
> H
>
Friday, March 23, 2012
msmqtask.dll
I tried to install the ENT edition of 2005, the release version. I continue to get an error stating the the install was unable to build the type lib for Microsoft.SqlServer.MsmqTask.dll.
I tried multiple uninstalls scenaios, including cleaning the registry, cleaning the file system, using the cleanup tool from the CTP, and I uninstalled MSMQ.
I can not seem to find my way out of this bag. The net result is that I can not import an existing Database. At least that's the first problem I found.
LT
This is an issue when Microsoft.SqlServer.MSMQTask is left behind in COM+ catalog. You can workaround it by:
1. Open Administrative Tools\Component Services
2. Go to Component Services\Computers\My Computer\COM+ Applications
3. Delete Microsoft.SqlServer.MSMQTask
|||
And what if you get this error and the Microsoft.SqlServer.MSMQTask is not there?
I clicked on ignore eventually, but this should not be ok.
|||The error also happens due to invalid or not enough rights in all the HKCR\Microsoft.SqlServer.Dts.Tasks. ... keys. The administrator group has only read access. Setting all keys of this group to full access solves this problemmsmqtask.dll
I tried to install the ENT edition of 2005, the release version. I continue to get an error stating the the install was unable to build the type lib for Microsoft.SqlServer.MsmqTask.dll.
I tried multiple uninstalls scenaios, including cleaning the registry, cleaning the file system, using the cleanup tool from the CTP, and I uninstalled MSMQ.
I can not seem to find my way out of this bag. The net result is that I can not import an existing Database. At least that's the first problem I found.
LT
This is an issue when Microsoft.SqlServer.MSMQTask is left behind in COM+ catalog. You can workaround it by:
1. Open Administrative Tools\Component Services
2. Go to Component Services\Computers\My Computer\COM+ Applications
3. Delete Microsoft.SqlServer.MSMQTask
|||
And what if you get this error and the Microsoft.SqlServer.MSMQTask is not there?
I clicked on ignore eventually, but this should not be ok.
|||The error also happens due to invalid or not enough rights in all the HKCR\Microsoft.SqlServer.Dts.Tasks. ... keys. The administrator group has only read access. Setting all keys of this group to full access solves this problemmsmqtask.dll
I tried to install the ENT edition of 2005, the release version. I continue to get an error stating the the install was unable to build the type lib for Microsoft.SqlServer.MsmqTask.dll.
MessageQueueTask
MessageQueueTask.ServerCompMQTask
There might be a few others becuase I gave permissions to a few before I starts running REGMON.
I tried multiple uninstalls scenaios, including cleaning the registry, cleaning the file system, using the cleanup tool from the CTP, and I uninstalled MSMQ.
I can not seem to find my way out of this bag. The net result is that I can not import an existing Database. At least that's the first problem I found.
LT
This is an issue when Microsoft.SqlServer.MSMQTask is left behind in COM+ catalog. You can workaround it by:
1. Open Administrative Tools\Component Services
2. Go to Component Services\Computers\My Computer\COM+ Applications
3. Delete Microsoft.SqlServer.MSMQTask
|||
And what if you get this error and the Microsoft.SqlServer.MSMQTask is not there?
I clicked on ignore eventually, but this should not be ok.
|||The error also happens due to invalid or not enough rights in all the HKCR\Microsoft.SqlServer.Dts.Tasks. ... keys. The administrator group has only read access. Setting all keys of this group to full access solves this problem|||I found some access denied keys, HKCR\Microsoft.SqlServer.DTS.TAks.MessageQueueTask.DataFileMessage keys....MessageQueueTask
MessageQueueTask.ServerCompMQTask
There might be a few others becuase I gave permissions to a few before I starts running REGMON.
Monday, March 19, 2012
Msg 624 Could not retrieve row from page by RID...
Running:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
I have a stored procedure that is returning the following error:
Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
Could not retrieve row from page by RID because the requested RID has a
higher number than the last RID on the page. Rid pageid is (1:5697) and row
num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
objectid = 1371279390, indexid = 0, DBID 2.
Connection Broken
Line 170 of the sp is running the following update:
Update f set
LinkID = OwnerOID
From #working f
JOIN EventDetail d on d.EventDetailID = f.EventDetailID
Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
If I comment out that update, the error goes away. Sounds like a corrupt
EventDetail index (PK is EventDetailID nonclustered). So I recreated the
table and all indexes. Still getting the error.
I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
table summaries):
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ELASAdmin'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Any idea where I should go from here?
TIA,
Scott
Additional info:
This error happens on multiple servers (production and dev)
DBID 2 is the tempdb (I did shut down SS and deleted the tempdb. After
restarting...same error.)
This SP had been running fine for about a year.
|||Product support might be the next place to do, unfortunately.
http://msdn.microsoft.com/library/de...err_1_23p0.asp
The only other thing I might try first is ANSI syntax for the update:
update #working set
LinkID = (
select OwnerOID
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
where exists (
select *
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
Steve Kass
Drew University
Scott wrote:
>Running:
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: )
>I have a stored procedure that is returning the following error:
>Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
>Could not retrieve row from page by RID because the requested RID has a
>higher number than the last RID on the page. Rid pageid is (1:5697) and row
>num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
>objectid = 1371279390, indexid = 0, DBID 2.
>Connection Broken
>Line 170 of the sp is running the following update:
>Update f set
> LinkID = OwnerOID
>From #working f
>JOIN EventDetail d on d.EventDetailID = f.EventDetailID
>Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
>If I comment out that update, the error goes away. Sounds like a corrupt
>EventDetail index (PK is EventDetailID nonclustered). So I recreated the
>table and all indexes. Still getting the error.
>I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
>table summaries):
>CHECKDB found 0 allocation errors and 0 consistency errors in database
>'ELASAdmin'.
>DBCC execution completed. If DBCC printed error messages, contact your
>system administrator.
>Any idea where I should go from here?
>TIA,
>Scott
>
>
|||I did see and completed the steps in the MSDN article before posting.
Your ANSI update worked! Do I dare ask why? Like I said, this SP has been
in production for over a year (its for a report that's emailed daily), then
on Friday I get this error.
I did look at the contents of #working just prior to the update and it only
contained about 30 records that looked 'normal'. I'll play around with it
some more on Monday...
Thanks for your help Steve,
Scott
"Steve Kass" <skass@.drew.edu> wrote in message
news:u0rIky$aEHA.556@.tk2msftngp13.phx.gbl...
> Product support might be the next place to do, unfortunately.
>
http://msdn.microsoft.com/library/de...err_1_23p0.asp[vbcol=seagreen]
> The only other thing I might try first is ANSI syntax for the update:
> update #working set
> LinkID = (
> select OwnerOID
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
> where exists (
> select *
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
>
> Steve Kass
> Drew University
> Scott wrote:
row[vbcol=seagreen]
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
I have a stored procedure that is returning the following error:
Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
Could not retrieve row from page by RID because the requested RID has a
higher number than the last RID on the page. Rid pageid is (1:5697) and row
num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
objectid = 1371279390, indexid = 0, DBID 2.
Connection Broken
Line 170 of the sp is running the following update:
Update f set
LinkID = OwnerOID
From #working f
JOIN EventDetail d on d.EventDetailID = f.EventDetailID
Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
If I comment out that update, the error goes away. Sounds like a corrupt
EventDetail index (PK is EventDetailID nonclustered). So I recreated the
table and all indexes. Still getting the error.
I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
table summaries):
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ELASAdmin'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Any idea where I should go from here?
TIA,
Scott
Additional info:
This error happens on multiple servers (production and dev)
DBID 2 is the tempdb (I did shut down SS and deleted the tempdb. After
restarting...same error.)
This SP had been running fine for about a year.
|||Product support might be the next place to do, unfortunately.
http://msdn.microsoft.com/library/de...err_1_23p0.asp
The only other thing I might try first is ANSI syntax for the update:
update #working set
LinkID = (
select OwnerOID
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
where exists (
select *
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
Steve Kass
Drew University
Scott wrote:
>Running:
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: )
>I have a stored procedure that is returning the following error:
>Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
>Could not retrieve row from page by RID because the requested RID has a
>higher number than the last RID on the page. Rid pageid is (1:5697) and row
>num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
>objectid = 1371279390, indexid = 0, DBID 2.
>Connection Broken
>Line 170 of the sp is running the following update:
>Update f set
> LinkID = OwnerOID
>From #working f
>JOIN EventDetail d on d.EventDetailID = f.EventDetailID
>Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
>If I comment out that update, the error goes away. Sounds like a corrupt
>EventDetail index (PK is EventDetailID nonclustered). So I recreated the
>table and all indexes. Still getting the error.
>I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
>table summaries):
>CHECKDB found 0 allocation errors and 0 consistency errors in database
>'ELASAdmin'.
>DBCC execution completed. If DBCC printed error messages, contact your
>system administrator.
>Any idea where I should go from here?
>TIA,
>Scott
>
>
|||I did see and completed the steps in the MSDN article before posting.
Your ANSI update worked! Do I dare ask why? Like I said, this SP has been
in production for over a year (its for a report that's emailed daily), then
on Friday I get this error.
I did look at the contents of #working just prior to the update and it only
contained about 30 records that looked 'normal'. I'll play around with it
some more on Monday...
Thanks for your help Steve,
Scott
"Steve Kass" <skass@.drew.edu> wrote in message
news:u0rIky$aEHA.556@.tk2msftngp13.phx.gbl...
> Product support might be the next place to do, unfortunately.
>
http://msdn.microsoft.com/library/de...err_1_23p0.asp[vbcol=seagreen]
> The only other thing I might try first is ANSI syntax for the update:
> update #working set
> LinkID = (
> select OwnerOID
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
> where exists (
> select *
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
>
> Steve Kass
> Drew University
> Scott wrote:
row[vbcol=seagreen]
Msg 624 Could not retrieve row from page by RID...
Running:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
I have a stored procedure that is returning the following error:
Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
Could not retrieve row from page by RID because the requested RID has a
higher number than the last RID on the page. Rid pageid is (1:5697) and row
num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
objectid = 1371279390, indexid = 0, DBID 2.
Connection Broken
Line 170 of the sp is running the following update:
Update f set
LinkID = OwnerOID
From #working f
JOIN EventDetail d on d.EventDetailID = f.EventDetailID
Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
If I comment out that update, the error goes away. Sounds like a corrupt
EventDetail index (PK is EventDetailID nonclustered). So I recreated the
table and all indexes. Still getting the error.
I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
table summaries):
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ELASAdmin'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Any idea where I should go from here?
TIA,
ScottAdditional info:
This error happens on multiple servers (production and dev)
DBID 2 is the tempdb (I did shut down SS and deleted the tempdb. After
restarting...same error.)
This SP had been running fine for about a year.|||Product support might be the next place to do, unfortunately.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23p0.asp
The only other thing I might try first is ANSI syntax for the update:
update #working set
LinkID = (
select OwnerOID
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
where exists (
select *
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
Steve Kass
Drew University
Scott wrote:
>Running:
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: )
>I have a stored procedure that is returning the following error:
>Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
>Could not retrieve row from page by RID because the requested RID has a
>higher number than the last RID on the page. Rid pageid is (1:5697) and row
>num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
>objectid = 1371279390, indexid = 0, DBID 2.
>Connection Broken
>Line 170 of the sp is running the following update:
>Update f set
> LinkID = OwnerOID
>From #working f
>JOIN EventDetail d on d.EventDetailID = f.EventDetailID
>Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
>If I comment out that update, the error goes away. Sounds like a corrupt
>EventDetail index (PK is EventDetailID nonclustered). So I recreated the
>table and all indexes. Still getting the error.
>I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
>table summaries):
>CHECKDB found 0 allocation errors and 0 consistency errors in database
>'ELASAdmin'.
>DBCC execution completed. If DBCC printed error messages, contact your
>system administrator.
>Any idea where I should go from here?
>TIA,
>Scott
>
>|||I did see and completed the steps in the MSDN article before posting.
Your ANSI update worked! Do I dare ask why? Like I said, this SP has been
in production for over a year (its for a report that's emailed daily), then
on Friday I get this error.
I did look at the contents of #working just prior to the update and it only
contained about 30 records that looked 'normal'. I'll play around with it
some more on Monday...
Thanks for your help Steve,
Scott
"Steve Kass" <skass@.drew.edu> wrote in message
news:u0rIky$aEHA.556@.tk2msftngp13.phx.gbl...
> Product support might be the next place to do, unfortunately.
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23p0.asp
> The only other thing I might try first is ANSI syntax for the update:
> update #working set
> LinkID = (
> select OwnerOID
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
> where exists (
> select *
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
>
> Steve Kass
> Drew University
> Scott wrote:
> >Running:
> >Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> > Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation
> > Standard Edition on Windows NT 5.2 (Build 3790: )
> >
> >I have a stored procedure that is returning the following error:
> >
> >Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
> >Could not retrieve row from page by RID because the requested RID has a
> >higher number than the last RID on the page. Rid pageid is (1:5697) and
row
> >num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
> >objectid = 1371279390, indexid = 0, DBID 2.
> >Connection Broken
> >
> >Line 170 of the sp is running the following update:
> >
> >Update f set
> > LinkID = OwnerOID
> >From #working f
> >JOIN EventDetail d on d.EventDetailID = f.EventDetailID
> >Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
> >
> >If I comment out that update, the error goes away. Sounds like a corrupt
> >EventDetail index (PK is EventDetailID nonclustered). So I recreated the
> >table and all indexes. Still getting the error.
> >
> >I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
> >table summaries):
> >CHECKDB found 0 allocation errors and 0 consistency errors in database
> >'ELASAdmin'.
> >DBCC execution completed. If DBCC printed error messages, contact your
> >system administrator.
> >
> >Any idea where I should go from here?
> >
> >TIA,
> >
> >Scott
> >
> >
> >
> >
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
I have a stored procedure that is returning the following error:
Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
Could not retrieve row from page by RID because the requested RID has a
higher number than the last RID on the page. Rid pageid is (1:5697) and row
num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
objectid = 1371279390, indexid = 0, DBID 2.
Connection Broken
Line 170 of the sp is running the following update:
Update f set
LinkID = OwnerOID
From #working f
JOIN EventDetail d on d.EventDetailID = f.EventDetailID
Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
If I comment out that update, the error goes away. Sounds like a corrupt
EventDetail index (PK is EventDetailID nonclustered). So I recreated the
table and all indexes. Still getting the error.
I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
table summaries):
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ELASAdmin'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Any idea where I should go from here?
TIA,
ScottAdditional info:
This error happens on multiple servers (production and dev)
DBID 2 is the tempdb (I did shut down SS and deleted the tempdb. After
restarting...same error.)
This SP had been running fine for about a year.|||Product support might be the next place to do, unfortunately.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23p0.asp
The only other thing I might try first is ANSI syntax for the update:
update #working set
LinkID = (
select OwnerOID
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
where exists (
select *
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
Steve Kass
Drew University
Scott wrote:
>Running:
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: )
>I have a stored procedure that is returning the following error:
>Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
>Could not retrieve row from page by RID because the requested RID has a
>higher number than the last RID on the page. Rid pageid is (1:5697) and row
>num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
>objectid = 1371279390, indexid = 0, DBID 2.
>Connection Broken
>Line 170 of the sp is running the following update:
>Update f set
> LinkID = OwnerOID
>From #working f
>JOIN EventDetail d on d.EventDetailID = f.EventDetailID
>Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
>If I comment out that update, the error goes away. Sounds like a corrupt
>EventDetail index (PK is EventDetailID nonclustered). So I recreated the
>table and all indexes. Still getting the error.
>I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
>table summaries):
>CHECKDB found 0 allocation errors and 0 consistency errors in database
>'ELASAdmin'.
>DBCC execution completed. If DBCC printed error messages, contact your
>system administrator.
>Any idea where I should go from here?
>TIA,
>Scott
>
>|||I did see and completed the steps in the MSDN article before posting.
Your ANSI update worked! Do I dare ask why? Like I said, this SP has been
in production for over a year (its for a report that's emailed daily), then
on Friday I get this error.
I did look at the contents of #working just prior to the update and it only
contained about 30 records that looked 'normal'. I'll play around with it
some more on Monday...
Thanks for your help Steve,
Scott
"Steve Kass" <skass@.drew.edu> wrote in message
news:u0rIky$aEHA.556@.tk2msftngp13.phx.gbl...
> Product support might be the next place to do, unfortunately.
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23p0.asp
> The only other thing I might try first is ANSI syntax for the update:
> update #working set
> LinkID = (
> select OwnerOID
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
> where exists (
> select *
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
>
> Steve Kass
> Drew University
> Scott wrote:
> >Running:
> >Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> > Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation
> > Standard Edition on Windows NT 5.2 (Build 3790: )
> >
> >I have a stored procedure that is returning the following error:
> >
> >Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
> >Could not retrieve row from page by RID because the requested RID has a
> >higher number than the last RID on the page. Rid pageid is (1:5697) and
row
> >num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
> >objectid = 1371279390, indexid = 0, DBID 2.
> >Connection Broken
> >
> >Line 170 of the sp is running the following update:
> >
> >Update f set
> > LinkID = OwnerOID
> >From #working f
> >JOIN EventDetail d on d.EventDetailID = f.EventDetailID
> >Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
> >
> >If I comment out that update, the error goes away. Sounds like a corrupt
> >EventDetail index (PK is EventDetailID nonclustered). So I recreated the
> >table and all indexes. Still getting the error.
> >
> >I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
> >table summaries):
> >CHECKDB found 0 allocation errors and 0 consistency errors in database
> >'ELASAdmin'.
> >DBCC execution completed. If DBCC printed error messages, contact your
> >system administrator.
> >
> >Any idea where I should go from here?
> >
> >TIA,
> >
> >Scott
> >
> >
> >
> >
Msg 624 Could not retrieve row from page by RID...
Running:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
I have a stored procedure that is returning the following error:
Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
Could not retrieve row from page by RID because the requested RID has a
higher number than the last RID on the page. Rid pageid is (1:5697) and row
num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
objectid = 1371279390, indexid = 0, DBID 2.
Connection Broken
Line 170 of the sp is running the following update:
Update f set
LinkID = OwnerOID
From #working f
JOIN EventDetail d on d.EventDetailID = f.EventDetailID
Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
If I comment out that update, the error goes away. Sounds like a corrupt
EventDetail index (PK is EventDetailID nonclustered). So I recreated the
table and all indexes. Still getting the error.
I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
table summaries):
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ELASAdmin'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Any idea where I should go from here?
TIA,
ScottAdditional info:
This error happens on multiple servers (production and dev)
DBID 2 is the tempdb (I did shut down SS and deleted the tempdb. After
restarting...same error.)
This SP had been running fine for about a year.|||Product support might be the next place to do, unfortunately.
http://msdn.microsoft.com/library/d...serr_1_23p0.asp
The only other thing I might try first is ANSI syntax for the update:
update #working set
LinkID = (
select OwnerOID
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
where exists (
select *
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
Steve Kass
Drew University
Scott wrote:
>Running:
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: )
>I have a stored procedure that is returning the following error:
>Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
>Could not retrieve row from page by RID because the requested RID has a
>higher number than the last RID on the page. Rid pageid is (1:5697) and row
>num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
>objectid = 1371279390, indexid = 0, DBID 2.
>Connection Broken
>Line 170 of the sp is running the following update:
>Update f set
> LinkID = OwnerOID
>From #working f
>JOIN EventDetail d on d.EventDetailID = f.EventDetailID
>Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
>If I comment out that update, the error goes away. Sounds like a corrupt
>EventDetail index (PK is EventDetailID nonclustered). So I recreated the
>table and all indexes. Still getting the error.
>I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
>table summaries):
>CHECKDB found 0 allocation errors and 0 consistency errors in database
>'ELASAdmin'.
>DBCC execution completed. If DBCC printed error messages, contact your
>system administrator.
>Any idea where I should go from here?
>TIA,
>Scott
>
>|||I did see and completed the steps in the MSDN article before posting.
Your ANSI update worked! Do I dare ask why? Like I said, this SP has been
in production for over a year (its for a report that's emailed daily), then
on Friday I get this error.
I did look at the contents of #working just prior to the update and it only
contained about 30 records that looked 'normal'. I'll play around with it
some more on Monday...
Thanks for your help Steve,
Scott
"Steve Kass" <skass@.drew.edu> wrote in message
news:u0rIky$aEHA.556@.tk2msftngp13.phx.gbl...
> Product support might be the next place to do, unfortunately.
>
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23p0.asp[
/url][vbcol=seagreen]
> The only other thing I might try first is ANSI syntax for the update:
> update #working set
> LinkID = (
> select OwnerOID
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
> where exists (
> select *
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
>
> Steve Kass
> Drew University
> Scott wrote:
>
row[vbcol=seagreen]
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
I have a stored procedure that is returning the following error:
Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
Could not retrieve row from page by RID because the requested RID has a
higher number than the last RID on the page. Rid pageid is (1:5697) and row
num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
objectid = 1371279390, indexid = 0, DBID 2.
Connection Broken
Line 170 of the sp is running the following update:
Update f set
LinkID = OwnerOID
From #working f
JOIN EventDetail d on d.EventDetailID = f.EventDetailID
Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
If I comment out that update, the error goes away. Sounds like a corrupt
EventDetail index (PK is EventDetailID nonclustered). So I recreated the
table and all indexes. Still getting the error.
I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
table summaries):
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ELASAdmin'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Any idea where I should go from here?
TIA,
ScottAdditional info:
This error happens on multiple servers (production and dev)
DBID 2 is the tempdb (I did shut down SS and deleted the tempdb. After
restarting...same error.)
This SP had been running fine for about a year.|||Product support might be the next place to do, unfortunately.
http://msdn.microsoft.com/library/d...serr_1_23p0.asp
The only other thing I might try first is ANSI syntax for the update:
update #working set
LinkID = (
select OwnerOID
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
where exists (
select *
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
Steve Kass
Drew University
Scott wrote:
>Running:
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: )
>I have a stored procedure that is returning the following error:
>Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
>Could not retrieve row from page by RID because the requested RID has a
>higher number than the last RID on the page. Rid pageid is (1:5697) and row
>num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
>objectid = 1371279390, indexid = 0, DBID 2.
>Connection Broken
>Line 170 of the sp is running the following update:
>Update f set
> LinkID = OwnerOID
>From #working f
>JOIN EventDetail d on d.EventDetailID = f.EventDetailID
>Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
>If I comment out that update, the error goes away. Sounds like a corrupt
>EventDetail index (PK is EventDetailID nonclustered). So I recreated the
>table and all indexes. Still getting the error.
>I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
>table summaries):
>CHECKDB found 0 allocation errors and 0 consistency errors in database
>'ELASAdmin'.
>DBCC execution completed. If DBCC printed error messages, contact your
>system administrator.
>Any idea where I should go from here?
>TIA,
>Scott
>
>|||I did see and completed the steps in the MSDN article before posting.
Your ANSI update worked! Do I dare ask why? Like I said, this SP has been
in production for over a year (its for a report that's emailed daily), then
on Friday I get this error.
I did look at the contents of #working just prior to the update and it only
contained about 30 records that looked 'normal'. I'll play around with it
some more on Monday...
Thanks for your help Steve,
Scott
"Steve Kass" <skass@.drew.edu> wrote in message
news:u0rIky$aEHA.556@.tk2msftngp13.phx.gbl...
> Product support might be the next place to do, unfortunately.
>
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23p0.asp[
/url][vbcol=seagreen]
> The only other thing I might try first is ANSI syntax for the update:
> update #working set
> LinkID = (
> select OwnerOID
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
> where exists (
> select *
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
>
> Steve Kass
> Drew University
> Scott wrote:
>
row[vbcol=seagreen]
Friday, March 9, 2012
MSDTS Transaction Failed.
Hi, we have sql server 2000 sp3 std edition installed on a windows 2000
server sp4. We are checking the logs for sql server and observe that
sometimes this error is displayed
Error: 8510, Severity: 20, State: 1
Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
Do you know what could be the reason'
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***This could be one reason for 8510 errors:
SQL Server error 8510 may be reported unnecessarily
http://support.microsoft.com/defaul...kb;en-us;307802
You are probably running into some other MSDTC problem if 8510 are logged to
SQL errorlogs. You should capture a Profiler trace on both linked servers
(with DTCTransaction and all Warnings and Error events) and review them for
other SQL errors leading up to 8510 errors. Also ensure that all connections
executing linked-server queries have SET XACT_ABORT ON.
Adrian
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:uYyL0kGRFHA.3076@.tk2msftngp13.phx.gbl...
> Hi, we have sql server 2000 sp3 std edition installed on a windows 2000
> server sp4. We are checking the logs for sql server and observe that
> sometimes this error is displayed
> Error: 8510, Severity: 20, State: 1
> Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
> Do you know what could be the reason'
> Thanks a lot for your help.
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
server sp4. We are checking the logs for sql server and observe that
sometimes this error is displayed
Error: 8510, Severity: 20, State: 1
Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
Do you know what could be the reason'
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***This could be one reason for 8510 errors:
SQL Server error 8510 may be reported unnecessarily
http://support.microsoft.com/defaul...kb;en-us;307802
You are probably running into some other MSDTC problem if 8510 are logged to
SQL errorlogs. You should capture a Profiler trace on both linked servers
(with DTCTransaction and all Warnings and Error events) and review them for
other SQL errors leading up to 8510 errors. Also ensure that all connections
executing linked-server queries have SET XACT_ABORT ON.
Adrian
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:uYyL0kGRFHA.3076@.tk2msftngp13.phx.gbl...
> Hi, we have sql server 2000 sp3 std edition installed on a windows 2000
> server sp4. We are checking the logs for sql server and observe that
> sometimes this error is displayed
> Error: 8510, Severity: 20, State: 1
> Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
> Do you know what could be the reason'
> Thanks a lot for your help.
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
MSDTS Transaction Failed.
Hi, we have sql server 2000 sp3 std edition installed on a windows 2000
server sp4. We are checking the logs for sql server and observe that
sometimes this error is displayed
Error: 8510, Severity: 20, State: 1
Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
Do you know what could be the reason?
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
This could be one reason for 8510 errors:
SQL Server error 8510 may be reported unnecessarily
http://support.microsoft.com/default...b;en-us;307802
You are probably running into some other MSDTC problem if 8510 are logged to
SQL errorlogs. You should capture a Profiler trace on both linked servers
(with DTCTransaction and all Warnings and Error events) and review them for
other SQL errors leading up to 8510 errors. Also ensure that all connections
executing linked-server queries have SET XACT_ABORT ON.
Adrian
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:uYyL0kGRFHA.3076@.tk2msftngp13.phx.gbl...
> Hi, we have sql server 2000 sp3 std edition installed on a windows 2000
> server sp4. We are checking the logs for sql server and observe that
> sometimes this error is displayed
> Error: 8510, Severity: 20, State: 1
> Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
> Do you know what could be the reason?
> Thanks a lot for your help.
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
server sp4. We are checking the logs for sql server and observe that
sometimes this error is displayed
Error: 8510, Severity: 20, State: 1
Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
Do you know what could be the reason?
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
This could be one reason for 8510 errors:
SQL Server error 8510 may be reported unnecessarily
http://support.microsoft.com/default...b;en-us;307802
You are probably running into some other MSDTC problem if 8510 are logged to
SQL errorlogs. You should capture a Profiler trace on both linked servers
(with DTCTransaction and all Warnings and Error events) and review them for
other SQL errors leading up to 8510 errors. Also ensure that all connections
executing linked-server queries have SET XACT_ABORT ON.
Adrian
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:uYyL0kGRFHA.3076@.tk2msftngp13.phx.gbl...
> Hi, we have sql server 2000 sp3 std edition installed on a windows 2000
> server sp4. We are checking the logs for sql server and observe that
> sometimes this error is displayed
> Error: 8510, Severity: 20, State: 1
> Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
> Do you know what could be the reason?
> Thanks a lot for your help.
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
MSDTS Transaction Failed.
Hi, we have sql server 2000 sp3 std edition installed on a windows 2000
server sp4. We are checking the logs for sql server and observe that
sometimes this error is displayed
Error: 8510, Severity: 20, State: 1
Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
Do you know what could be the reason'
Thanks a lot for your help.
*** Sent via Developersdex http://www.developersdex.com ***This could be one reason for 8510 errors:
SQL Server error 8510 may be reported unnecessarily
http://support.microsoft.com/default.aspx?scid=kb;en-us;307802
You are probably running into some other MSDTC problem if 8510 are logged to
SQL errorlogs. You should capture a Profiler trace on both linked servers
(with DTCTransaction and all Warnings and Error events) and review them for
other SQL errors leading up to 8510 errors. Also ensure that all connections
executing linked-server queries have SET XACT_ABORT ON.
Adrian
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:uYyL0kGRFHA.3076@.tk2msftngp13.phx.gbl...
> Hi, we have sql server 2000 sp3 std edition installed on a windows 2000
> server sp4. We are checking the logs for sql server and observe that
> sometimes this error is displayed
> Error: 8510, Severity: 20, State: 1
> Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
> Do you know what could be the reason'
> Thanks a lot for your help.
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
server sp4. We are checking the logs for sql server and observe that
sometimes this error is displayed
Error: 8510, Severity: 20, State: 1
Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
Do you know what could be the reason'
Thanks a lot for your help.
*** Sent via Developersdex http://www.developersdex.com ***This could be one reason for 8510 errors:
SQL Server error 8510 may be reported unnecessarily
http://support.microsoft.com/default.aspx?scid=kb;en-us;307802
You are probably running into some other MSDTC problem if 8510 are logged to
SQL errorlogs. You should capture a Profiler trace on both linked servers
(with DTCTransaction and all Warnings and Error events) and review them for
other SQL errors leading up to 8510 errors. Also ensure that all connections
executing linked-server queries have SET XACT_ABORT ON.
Adrian
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:uYyL0kGRFHA.3076@.tk2msftngp13.phx.gbl...
> Hi, we have sql server 2000 sp3 std edition installed on a windows 2000
> server sp4. We are checking the logs for sql server and observe that
> sometimes this error is displayed
> Error: 8510, Severity: 20, State: 1
> Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
> Do you know what could be the reason'
> Thanks a lot for your help.
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
Wednesday, March 7, 2012
MSDTC service does not install with developer edition?
Ok I have tried this on a 2000 server box and an XP Pro box and both times
it has our Developer edition SQL install has not installed (service is not
listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?Check SQLSTP.LOG for more information on this failure.
Because some services may cause installation failure of SQL Server due to a
Windows NT/2000 logon failure or time out, you should stop these services be
fore installing SQL Server 2000, and then restart them once SQL Server has b
een successfully installed.
Stop the following services:
IIS - Internet Information Server
Exchange Server
SNA Server
Disk Keeper
SNMP Service
Anti-virus software (such as McAfee)
Backup products (such as ARC Server)
If you cannot install MS DTC on a server with multiple network cards or SPX
installed, uninstall one of the network cards or SPX, and then retry the SQL
Server Setup.
Check the following files:
sqlstp.log (located in your \Windows or \WinNT directory)
errorlog file (located in the \Log directory of the target installation dire
ctory)
setup.log file (located in your \Windows or \WinNT directory)
"James Morton" wrote:
> Ok I have tried this on a 2000 server box and an XP Pro box and both times
> it has our Developer edition SQL install has not installed (service is not
> listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
>
>|||MSDTC is a Operating System component, and does not get installed by SQL
Server since SQL Server 6.5.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"James Morton" <james_morton@.hotmail.com> wrote in message
news:e9Y7v5SZEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Ok I have tried this on a 2000 server box and an XP Pro box and both times
> it has our Developer edition SQL install has not installed (service is not
> listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
>
it has our Developer edition SQL install has not installed (service is not
listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?Check SQLSTP.LOG for more information on this failure.
Because some services may cause installation failure of SQL Server due to a
Windows NT/2000 logon failure or time out, you should stop these services be
fore installing SQL Server 2000, and then restart them once SQL Server has b
een successfully installed.
Stop the following services:
IIS - Internet Information Server
Exchange Server
SNA Server
Disk Keeper
SNMP Service
Anti-virus software (such as McAfee)
Backup products (such as ARC Server)
If you cannot install MS DTC on a server with multiple network cards or SPX
installed, uninstall one of the network cards or SPX, and then retry the SQL
Server Setup.
Check the following files:
sqlstp.log (located in your \Windows or \WinNT directory)
errorlog file (located in the \Log directory of the target installation dire
ctory)
setup.log file (located in your \Windows or \WinNT directory)
"James Morton" wrote:
> Ok I have tried this on a 2000 server box and an XP Pro box and both times
> it has our Developer edition SQL install has not installed (service is not
> listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
>
>|||MSDTC is a Operating System component, and does not get installed by SQL
Server since SQL Server 6.5.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"James Morton" <james_morton@.hotmail.com> wrote in message
news:e9Y7v5SZEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Ok I have tried this on a 2000 server box and an XP Pro box and both times
> it has our Developer edition SQL install has not installed (service is not
> listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
>
MSDTC service does not install with developer edition?
Ok I have tried this on a 2000 server box and an XP Pro box and both times
it has our Developer edition SQL install has not installed (service is not
listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
Check SQLSTP.LOG for more information on this failure.
Because some services may cause installation failure of SQL Server due to a Windows NT/2000 logon failure or time out, you should stop these services before installing SQL Server 2000, and then restart them once SQL Server has been successfully installed.
Stop the following services:
IIS - Internet Information Server
Exchange Server
SNA Server
Disk Keeper
SNMP Service
Anti-virus software (such as McAfee)
Backup products (such as ARC Server)
If you cannot install MS DTC on a server with multiple network cards or SPX installed, uninstall one of the network cards or SPX, and then retry the SQL Server Setup.
Check the following files:
sqlstp.log (located in your \Windows or \WinNT directory)
errorlog file (located in the \Log directory of the target installation directory)
setup.log file (located in your \Windows or \WinNT directory)
"James Morton" wrote:
> Ok I have tried this on a 2000 server box and an XP Pro box and both times
> it has our Developer edition SQL install has not installed (service is not
> listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
>
>
|||MSDTC is a Operating System component, and does not get installed by SQL
Server since SQL Server 6.5.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"James Morton" <james_morton@.hotmail.com> wrote in message
news:e9Y7v5SZEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Ok I have tried this on a 2000 server box and an XP Pro box and both times
> it has our Developer edition SQL install has not installed (service is not
> listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
>
it has our Developer edition SQL install has not installed (service is not
listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
Check SQLSTP.LOG for more information on this failure.
Because some services may cause installation failure of SQL Server due to a Windows NT/2000 logon failure or time out, you should stop these services before installing SQL Server 2000, and then restart them once SQL Server has been successfully installed.
Stop the following services:
IIS - Internet Information Server
Exchange Server
SNA Server
Disk Keeper
SNMP Service
Anti-virus software (such as McAfee)
Backup products (such as ARC Server)
If you cannot install MS DTC on a server with multiple network cards or SPX installed, uninstall one of the network cards or SPX, and then retry the SQL Server Setup.
Check the following files:
sqlstp.log (located in your \Windows or \WinNT directory)
errorlog file (located in the \Log directory of the target installation directory)
setup.log file (located in your \Windows or \WinNT directory)
"James Morton" wrote:
> Ok I have tried this on a 2000 server box and an XP Pro box and both times
> it has our Developer edition SQL install has not installed (service is not
> listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
>
>
|||MSDTC is a Operating System component, and does not get installed by SQL
Server since SQL Server 6.5.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"James Morton" <james_morton@.hotmail.com> wrote in message
news:e9Y7v5SZEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Ok I have tried this on a 2000 server box and an XP Pro box and both times
> it has our Developer edition SQL install has not installed (service is not
> listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
>
MSDTC service does not install with developer edition?
Ok I have tried this on a 2000 server box and an XP Pro box and both times
it has our Developer edition SQL install has not installed (service is not
listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?Check SQLSTP.LOG for more information on this failure.
Because some services may cause installation failure of SQL Server due to a Windows NT/2000 logon failure or time out, you should stop these services before installing SQL Server 2000, and then restart them once SQL Server has been successfully installed. Stop the following services:
IIS - Internet Information Server
Exchange Server
SNA Server
Disk Keeper
SNMP Service
Anti-virus software (such as McAfee)
Backup products (such as ARC Server)
If you cannot install MS DTC on a server with multiple network cards or SPX installed, uninstall one of the network cards or SPX, and then retry the SQL Server Setup.
Check the following files:
sqlstp.log (located in your \Windows or \WinNT directory)
errorlog file (located in the \Log directory of the target installation directory)
setup.log file (located in your \Windows or \WinNT directory)
"James Morton" wrote:
> Ok I have tried this on a 2000 server box and an XP Pro box and both times
> it has our Developer edition SQL install has not installed (service is not
> listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
>
>|||MSDTC is a Operating System component, and does not get installed by SQL
Server since SQL Server 6.5.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"James Morton" <james_morton@.hotmail.com> wrote in message
news:e9Y7v5SZEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Ok I have tried this on a 2000 server box and an XP Pro box and both times
> it has our Developer edition SQL install has not installed (service is not
> listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
>
it has our Developer edition SQL install has not installed (service is not
listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?Check SQLSTP.LOG for more information on this failure.
Because some services may cause installation failure of SQL Server due to a Windows NT/2000 logon failure or time out, you should stop these services before installing SQL Server 2000, and then restart them once SQL Server has been successfully installed. Stop the following services:
IIS - Internet Information Server
Exchange Server
SNA Server
Disk Keeper
SNMP Service
Anti-virus software (such as McAfee)
Backup products (such as ARC Server)
If you cannot install MS DTC on a server with multiple network cards or SPX installed, uninstall one of the network cards or SPX, and then retry the SQL Server Setup.
Check the following files:
sqlstp.log (located in your \Windows or \WinNT directory)
errorlog file (located in the \Log directory of the target installation directory)
setup.log file (located in your \Windows or \WinNT directory)
"James Morton" wrote:
> Ok I have tried this on a 2000 server box and an XP Pro box and both times
> it has our Developer edition SQL install has not installed (service is not
> listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
>
>|||MSDTC is a Operating System component, and does not get installed by SQL
Server since SQL Server 6.5.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"James Morton" <james_morton@.hotmail.com> wrote in message
news:e9Y7v5SZEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Ok I have tried this on a 2000 server box and an XP Pro box and both times
> it has our Developer edition SQL install has not installed (service is not
> listed) nor is their an .exe. Any ideas? Is our dev edition image hosed?
>
Subscribe to:
Posts (Atom)