Need to sum columns: dbcc

Showing posts with label dbcc. Show all posts

Friday, March 30, 2012

Network error when running a query

Running long queries (mostly DBCC commands) on SQL Server 2000 SP3 I receive
an error very often
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead())
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation."
How can I fix it?Hi,
Do you have SQL Server on Windows 2003?
If you do, try removing Named Pipes from Enabled Network Libraries in Server
Network Utility.
--
Danijel Novak
"Elena" <Elena@.discussions.microsoft.com> wrote in message
news:07702D19-01BA-4A62-9F1B-CC758C1C4460@.microsoft.com...
> Running long queries (mostly DBCC commands) on SQL Server 2000 SP3 I
> receive
> an error very often
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (WrapperRead())
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation."
> How can I fix it?
>|||Thanks for reply, Danijel. Yes, SQL Server 2000 is running on Windows Server
2003 machine. But how will removing Named Piies influence application
performance? Do I need to stop and restart production server after
reconfiguration?
Elena
"Danijel Novak" wrote:
> Hi,
> Do you have SQL Server on Windows 2003?
> If you do, try removing Named Pipes from Enabled Network Libraries in Server
> Network Utility.
> --
> Danijel Novak
>
> "Elena" <Elena@.discussions.microsoft.com> wrote in message
> news:07702D19-01BA-4A62-9F1B-CC758C1C4460@.microsoft.com...
> > Running long queries (mostly DBCC commands) on SQL Server 2000 SP3 I
> > receive
> > an error very often
> > "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> > (WrapperRead())
> > Server: Msg 11, Level 16, State 1, Line 0
> > General network error. Check your network documentation."
> > How can I fix it?
> >
>
>|||Hi,
removing Named Pipes should not influence application performance. Just keep
TCP/IP in there.
I'm not sure about restarting the service but I think you don't have to
restart SQL Server for that.
--
Danijel Novak
"Elena" <Elena@.discussions.microsoft.com> wrote in message
news:0CD3D9ED-DA33-4D7B-BDD3-C3C486158A68@.microsoft.com...
> Thanks for reply, Danijel. Yes, SQL Server 2000 is running on Windows
> Server
> 2003 machine. But how will removing Named Piies influence application
> performance? Do I need to stop and restart production server after
> reconfiguration?
> Elena
> "Danijel Novak" wrote:
>> Hi,
>> Do you have SQL Server on Windows 2003?
>> If you do, try removing Named Pipes from Enabled Network Libraries in
>> Server
>> Network Utility.
>> --
>> Danijel Novak
>>
>> "Elena" <Elena@.discussions.microsoft.com> wrote in message
>> news:07702D19-01BA-4A62-9F1B-CC758C1C4460@.microsoft.com...
>> > Running long queries (mostly DBCC commands) on SQL Server 2000 SP3 I
>> > receive
>> > an error very often
>> > "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
>> > (WrapperRead())
>> > Server: Msg 11, Level 16, State 1, Line 0
>> > General network error. Check your network documentation."
>> > How can I fix it?
>> >
>>

Network error when running a query

Friday, March 9, 2012

Negative Stolen buffers value

If I run DBCC MemoryStatus and I get a negative value for Stolen in the
Buffer Distributions section, what does a negative value indicate? For
example:
Buffer Distribution Buffers
-- --
Stolen -228001
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200703/1
I'm not sure of it, because you did'nt explain you current "platform", but
meybe the following article could be useful:
http://support.microsoft.com/kb/907877/en-us
(look at NUMA exceptions)
"cbrichards via droptable.com" wrote:

> If I run DBCC MemoryStatus and I get a negative value for Stolen in the
> Buffer Distributions section, what does a negative value indicate? For
> example:
> Buffer Distribution Buffers
> -- --
> Stolen -228001
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server/200703/1
>
|||Thanks Gilberto, but the link you sent did not address a negative value.
We are running SQL Server 2005, SP2 on Win 2K3
Gilberto Zampatti wrote:[vbcol=seagreen]
>I'm not sure of it, because you did'nt explain you current "platform", but
>meybe the following article could be useful:
>http://support.microsoft.com/kb/907877/en-us
>(look at NUMA exceptions)
>[quoted text clipped - 3 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200703/1
|||The link i've suggested is interestinf just because it mention possible wrong
values in NUMA environments. I think a negative value could be interpreted as
wrong, because i don't find documentation explaining otherwise such a value.
Effectively, the article speculates about AWE counters and not Stolen
buffers counter...
Gilberto
"cbrichards via droptable.com" wrote:

> Thanks Gilberto, but the link you sent did not address a negative value.
> We are running SQL Server 2005, SP2 on Win 2K3
> Gilberto Zampatti wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server/200703/1
>

Negative Stolen buffers value

If I run DBCC MemoryStatus and I get a negative value for Stolen in the
Buffer Distributions section, what does a negative value indicate? For
example:
Buffer Distribution Buffers
-- --
Stolen -228001
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200703/1I'm not sure of it, because you did'nt explain you current "platform", but
meybe the following article could be useful:
http://support.microsoft.com/kb/907877/en-us
(look at NUMA exceptions)
"cbrichards via SQLMonster.com" wrote:
> If I run DBCC MemoryStatus and I get a negative value for Stolen in the
> Buffer Distributions section, what does a negative value indicate? For
> example:
> Buffer Distribution Buffers
> -- --
> Stolen -228001
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200703/1
>|||Thanks Gilberto, but the link you sent did not address a negative value.
We are running SQL Server 2005, SP2 on Win 2K3
Gilberto Zampatti wrote:
>I'm not sure of it, because you did'nt explain you current "platform", but
>meybe the following article could be useful:
>http://support.microsoft.com/kb/907877/en-us
>(look at NUMA exceptions)
>> If I run DBCC MemoryStatus and I get a negative value for Stolen in the
>> Buffer Distributions section, what does a negative value indicate? For
>[quoted text clipped - 3 lines]
>> -- --
>> Stolen -228001
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200703/1|||The link i've suggested is interestinf just because it mention possible wrong
values in NUMA environments. I think a negative value could be interpreted as
wrong, because i don't find documentation explaining otherwise such a value.
Effectively, the article speculates about AWE counters and not Stolen
buffers counter...
Gilberto
"cbrichards via SQLMonster.com" wrote:
> Thanks Gilberto, but the link you sent did not address a negative value.
> We are running SQL Server 2005, SP2 on Win 2K3
> Gilberto Zampatti wrote:
> >I'm not sure of it, because you did'nt explain you current "platform", but
> >meybe the following article could be useful:
> >http://support.microsoft.com/kb/907877/en-us
> >
> >(look at NUMA exceptions)
> >
> >> If I run DBCC MemoryStatus and I get a negative value for Stolen in the
> >> Buffer Distributions section, what does a negative value indicate? For
> >[quoted text clipped - 3 lines]
> >> -- --
> >> Stolen -228001
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200703/1
>

Negative Stolen buffers value

If I run DBCC MemoryStatus and I get a negative value for Stolen in the
Buffer Distributions section, what does a negative value indicate? For
example:
Buffer Distribution Buffers
-- --
Stolen -228001
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200703/1I'm not sure of it, because you did'nt explain you current "platform", but
meybe the following article could be useful:
http://support.microsoft.com/kb/907877/en-us
(look at NUMA exceptions)
"cbrichards via droptable.com" wrote:

> If I run DBCC MemoryStatus and I get a negative value for Stolen in the
> Buffer Distributions section, what does a negative value indicate? For
> example:
> Buffer Distribution Buffers
> -- --
> Stolen -228001
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200703/1
>|||Thanks Gilberto, but the link you sent did not address a negative value.
We are running SQL Server 2005, SP2 on Win 2K3
Gilberto Zampatti wrote:[vbcol=seagreen]
>I'm not sure of it, because you did'nt explain you current "platform", but
>meybe the following article could be useful:
>http://support.microsoft.com/kb/907877/en-us
>(look at NUMA exceptions)
>
>[quoted text clipped - 3 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200703/1|||The link i've suggested is interestinf just because it mention possible wron
g
values in NUMA environments. I think a negative value could be interpreted a
s
wrong, because i don't find documentation explaining otherwise such a value.
Effectively, the article speculates about AWE counters and not Stolen
buffers counter...
Gilberto
"cbrichards via droptable.com" wrote:

> Thanks Gilberto, but the link you sent did not address a negative value.
> We are running SQL Server 2005, SP2 on Win 2K3
> Gilberto Zampatti wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200703/1
>

Friday, March 30, 2012

Network error when running a query

Network error when running a query

Network error when running a query

Friday, March 9, 2012

Negative Stolen buffers value

Negative Stolen buffers value

Negative Stolen buffers value

Need to sum columns

Blog Archive

About Me