Parity

I am experiencing misterious parity errors on an HP ML570 G2 system running
32GB of memory and quad 2.8 CPU's.
Windows 2003 Enterprise and SQl Enterprise SP3A.
I have updated all drivers and firmware and ran comnprehensive diags on the
system and everything checks out OK.
The system misteriously goes to a blue screen stating a parity errors.
Unfortunately, there are no errors generated that I can go on.
Has anyone experienced this in their envirionments.
teh boot.ini switches are set correctly and AWE is enabled.
Anything would help. Thanks
Garry.First, have you tried the MAXMEM switch in the Boot.ini? maybe limit the OS
to, say, 8GB to see if the issue resolves itself (could still be bad memory
as I rarely trust memory diags). Microsoft does have it's own memory diags.
that I have seen somewhere...I will try to dig it up
What is the exact error your do see with the BSOD? anything helpful at the
HP site?
Neil MacMurchy
"GSM" <gsm@.mris.com> wrote in message
news:ebyIFBTBEHA.3284@.TK2MSFTNGP09.phx.gbl...
> I am experiencing misterious parity errors on an HP ML570 G2 system
running
> 32GB of memory and quad 2.8 CPU's.
> Windows 2003 Enterprise and SQl Enterprise SP3A.
> I have updated all drivers and firmware and ran comnprehensive diags on
the
> system and everything checks out OK.
> The system misteriously goes to a blue screen stating a parity errors.
> Unfortunately, there are no errors generated that I can go on.
> Has anyone experienced this in their envirionments.
> teh boot.ini switches are set correctly and AWE is enabled.
> Anything would help. Thanks
> Garry.
>|||We are not using MAXMEM, only the /PAE switch.
Unfortunately HP is pointing at firmware and drivers. All updated as per
forum visits.
The exact error at BSOD states:
Hardware Error
Call your hardware vendor for support
NMI: Parity check/memory parity error
***The system has haulted***
"Neil MacMurchy" <neilmcse@.hotmail.com> wrote in message
news:%23XwrsYTBEHA.3928@.TK2MSFTNGP09.phx.gbl...
> First, have you tried the MAXMEM switch in the Boot.ini? maybe limit the
OS
> to, say, 8GB to see if the issue resolves itself (could still be bad
memory
> as I rarely trust memory diags). Microsoft does have it's own memory
diags.
> that I have seen somewhere...I will try to dig it up
> What is the exact error your do see with the BSOD? anything helpful at the
> HP site?
> Neil MacMurchy
> "GSM" <gsm@.mris.com> wrote in message
> news:ebyIFBTBEHA.3284@.TK2MSFTNGP09.phx.gbl...
> running
> the
>|||<flame>Harumph, typical HP </flame>
http://support.microsoft.com/defaul...kb;en-us;222973
If you have a support contract I would have them come in. is this straight
off of startup all the time or is it intermittent and not reproducable?
Neil
"GSM" <gsm@.mris.com> wrote in message
news:O$XUcrTBEHA.892@.TK2MSFTNGP09.phx.gbl...
> We are not using MAXMEM, only the /PAE switch.
> Unfortunately HP is pointing at firmware and drivers. All updated as per
> forum visits.
> The exact error at BSOD states:
> hardware Error
> Call your hardware vendor for support
> NMI: Parity check/memory parity error
> ***The system has haulted***
> "Neil MacMurchy" <neilmcse@.hotmail.com> wrote in message
> news:%23XwrsYTBEHA.3928@.TK2MSFTNGP09.phx.gbl...
> OS
> memory
> diags.
the
on
>|||Unfortunately intermittent and it's never been reproducable. That's what is
killing me. Diagnosing and troubleshotting is not quick. We find ourselves
waiting for the problem (sometimes for days) after taking different measures
to correct it.
"Neil MacMurchy" <neilmcse@.hotmail.com> wrote in message
news:u$i$9zTBEHA.3776@.tk2msftngp13.phx.gbl...
> <flame>Harumph, typical HP </flame>
> http://support.microsoft.com/defaul...kb;en-us;222973
> If you have a support contract I would have them come in. is this straight
> off of startup all the time or is it intermittent and not reproducable?
> Neil
> "GSM" <gsm@.mris.com> wrote in message
> news:O$XUcrTBEHA.892@.TK2MSFTNGP09.phx.gbl...
per
the
> the
> on
errors.
>|||Again I would hassle HP. unit should be under wty (my DL580 G2s are still
under wty). I would start stripping out some of the RAM to double check.
Possibly down to 4GB.
Were there any changes just prior to all of this? Don't discount NICs or
other adapters as possible sources.
We had some problems with an old 6500 recently and it was RAM. Diags tested
ok, but after we stripped it down to 256MB our reproducable error (could
make it happen every time we did a BIG copy) went away. I had the benifit of
a reproducable error . See if you can find a way to make yours reproduce
(little baby errors all over the place <gr> )
Neil
"GSM" <gsm@.mris.com> wrote in message
news:uRWwVQUBEHA.712@.tk2msftngp13.phx.gbl...
> Unfortunately intermittent and it's never been reproducable. That's what
is
> killing me. Diagnosing and troubleshotting is not quick. We find
ourselves
> waiting for the problem (sometimes for days) after taking different
measures
> to correct it.
>
> "Neil MacMurchy" <neilmcse@.hotmail.com> wrote in message
> news:u$i$9zTBEHA.3776@.tk2msftngp13.phx.gbl...
straight
> per
> the
at
system
diags
> errors.
>|||I will keep at it on all fronts and will repost for everyones benefit.
Please keep me posted should you come across anything.
Many thanks.
"Neil MacMurchy" <neilmcse@.hotmail.com> wrote in message
news:ujnAwUUBEHA.3204@.TK2MSFTNGP10.phx.gbl...
> Again I would hassle HP. unit should be under wty (my DL580 G2s are still
> under wty). I would start stripping out some of the RAM to double check.
> Possibly down to 4GB.
> Were there any changes just prior to all of this? Don't discount NICs or
> other adapters as possible sources.
> We had some problems with an old 6500 recently and it was RAM. Diags
tested
> ok, but after we stripped it down to 256MB our reproducable error (could
> make it happen every time we did a BIG copy) went away. I had the benifit
of
> a reproducable error . See if you can find a way to make yours reproduce
> (little baby errors all over the place <gr> )
> Neil
> "GSM" <gsm@.mris.com> wrote in message
> news:uRWwVQUBEHA.712@.tk2msftngp13.phx.gbl...
what
> is
> ourselves
> measures
> straight
reproducable?
as
limit
bad
memory
helpful
> at
> system
> diags
>|||Wait for the bill (I take my coffe with 2 cream and 2 sugar, but please
don't send it thru the mail...)
;-)
(ps...good luck)
Neil
"GSM" <gsm@.mris.com> wrote in message
news:u5xL6gUBEHA.1732@.TK2MSFTNGP12.phx.gbl...
> I will keep at it on all fronts and will repost for everyones benefit.
> Please keep me posted should you come across anything.
> Many thanks.
> "Neil MacMurchy" <neilmcse@.hotmail.com> wrote in message
> news:ujnAwUUBEHA.3204@.TK2MSFTNGP10.phx.gbl...
still
> tested
benifit
> of
> what
> reproducable?
> as
> limit
> bad
> memory
> helpful
>

Partitioning Questions

I'm looking at using table partitioning in SQL 2005 and have a few
questions.
a.. Is partitioning really only available in Enterprise Edition? I have
Std Edition and when I tried to create a partitioning function, it told me
"Partition function can only be created in Enterprise edition of SQL Server.
Only Enterprise edition of SQL Server supports partitioning." Yet I don't
see this same statement anywhere in the documentation.
b.. All of the articles I'm reading on partitioning talk about how to
create a new table and use partitioning. How do I partition an existing
table?
c.. Does partitioning work equally well with datetime and int columns?
d.. Will partitioning give me better performance than say moving my
indexes to another filegroup?
Thanks, AndréHi André
Take a look in BOL at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/81f3e917-884a-4cc8-aca2-0a5fea89f355.htm
"Features supported by the Editions of SQL Server 2005
--
HTH
Kalen Delaney, SQL Server MVP
"Andre" <no@.spam.com> wrote in message
news:%23be3$PZhGHA.3496@.TK2MSFTNGP04.phx.gbl...
> I'm looking at using table partitioning in SQL 2005 and have a few
> questions.
> a.. Is partitioning really only available in Enterprise Edition? I have
> Std Edition and when I tried to create a partitioning function, it told me
> "Partition function can only be created in Enterprise edition of SQL
> Server. Only Enterprise edition of SQL Server supports partitioning." Yet
> I don't see this same statement anywhere in the documentation.
> b.. All of the articles I'm reading on partitioning talk about how to
> create a new table and use partitioning. How do I partition an existing
> table?
> c.. Does partitioning work equally well with datetime and int columns?
> d.. Will partitioning give me better performance than say moving my
> indexes to another filegroup?
>
> Thanks, André
>
>|||Please check the topic "Modifying Partitioned Tables and Indexes"
in BOL at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/1b85f670-74aa-4a4b-9a88-3352f1d274d1.htm
It gives details for each of the following:
You can modify partitioned tables and indexes in the following ways:
a.. Modify a partition function to re-partition any tables or indexes that
participate in it.
b.. Modify a partition scheme to designate a filegroup to hold a
newly-added partition.
c.. Convert a nonpartitioned table to a partitioned table.
<===============
d.. Convert a partitioned table to a nonpartitioned table.
e.. Transfer data by adding, moving, or removing partitions
--
HTH
Kalen Delaney, SQL Server MVP
"Andre" <no@.spam.com> wrote in message
news:etHWW3ahGHA.4776@.TK2MSFTNGP05.phx.gbl...
> Thanks Kalen. Do you by chance have any good links that talk about how to
> partition an existing table?
> Andre
>|||Thanks Kalen. Do you by chance have any good links that talk about how to
partition an existing table?
Andre|||Thanks Kalen - I'll check this out.
Andre

Partitioning Questions

I'm looking at using table partitioning in SQL 2005 and have a few
questions.
a.. Is partitioning really only available in Enterprise Edition? I have
Std Edition and when I tried to create a partitioning function, it told me
"Partition function can only be created in Enterprise edition of SQL Server.
Only Enterprise edition of SQL Server supports partitioning." Yet I don't
see this same statement anywhere in the documentation.
b.. All of the articles I'm reading on partitioning talk about how to
create a new table and use partitioning. How do I partition an existing
table?
c.. Does partitioning work equally well with datetime and int columns?
d.. Will partitioning give me better performance than say moving my
indexes to another filegroup?
Thanks, AndrHi Andr
Take a look in BOL at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/81f3e917-884a-4cc8-aca2-
0a5fea89f355.htm
"Features supported by the Editions of SQL Server 2005
HTH
Kalen Delaney, SQL Server MVP
"Andre" <no@.spam.com> wrote in message
news:%23be3$PZhGHA.3496@.TK2MSFTNGP04.phx.gbl...
> I'm looking at using table partitioning in SQL 2005 and have a few
> questions.
> a.. Is partitioning really only available in Enterprise Edition? I have
> Std Edition and when I tried to create a partitioning function, it told me
> "Partition function can only be created in Enterprise edition of SQL
> Server. Only Enterprise edition of SQL Server supports partitioning." Yet
> I don't see this same statement anywhere in the documentation.
> b.. All of the articles I'm reading on partitioning talk about how to
> create a new table and use partitioning. How do I partition an existing
> table?
> c.. Does partitioning work equally well with datetime and int columns?
> d.. Will partitioning give me better performance than say moving my
> indexes to another filegroup?
>
> Thanks, Andr
>
>|||Thanks Kalen. Do you by chance have any good links that talk about how to
partition an existing table?
Andre|||Please check the topic "Modifying Partitioned Tables and Indexes"
in BOL at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/1b85f670-74aa-4a4b-9a88-3352
f1d274d1.htm
It gives details for each of the following:
You can modify partitioned tables and indexes in the following ways:
a.. Modify a partition function to re-partition any tables or indexes that
participate in it.
b.. Modify a partition scheme to designate a filegroup to hold a
newly-added partition.
c.. Convert a nonpartitioned table to a partitioned table.
<===============
d.. Convert a partitioned table to a nonpartitioned table.
e.. Transfer data by adding, moving, or removing partitions
--
HTH
Kalen Delaney, SQL Server MVP
"Andre" <no@.spam.com> wrote in message
news:etHWW3ahGHA.4776@.TK2MSFTNGP05.phx.gbl...
> Thanks Kalen. Do you by chance have any good links that talk about how to
> partition an existing table?
> Andre
>|||Thanks Kalen - I'll check this out.
Andre