Re-installing Report Server

I had to uninstall Report Server and Report Designer on are
SQL server machine because of bandwidth concerns. Instead, Im installing
Report Server and Report Designer on a different member server. However the
Report databases remain after the uninstall on the SQL server machine. Is
this ok for these databases to remain? Will the new install try and create a
separate set of databases? I've already run RSkeymgmnt utility and saved the
key file. Is there a different procedure to follow in reinstalling on a
different server? By the way no work was done on the first installation, so
these databases really contain no important data.
MarkIf you don't need the databases, you can delete them. You only needed to
save the key file if you were planning to reuse the old database.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark C" <MarkC@.discussions.microsoft.com> wrote in message
news:E80AE112-31C1-4FA0-BFF5-5A6595C339C8@.microsoft.com...
>I had to uninstall Report Server and Report Designer on are
> SQL server machine because of bandwidth concerns. Instead, Im installing
> Report Server and Report Designer on a different member server. However
> the
> Report databases remain after the uninstall on the SQL server machine. Is
> this ok for these databases to remain? Will the new install try and create
> a
> separate set of databases? I've already run RSkeymgmnt utility and saved
> the
> key file. Is there a different procedure to follow in reinstalling on a
> different server? By the way no work was done on the first installation,
> so
> these databases really contain no important data.
> Marksql

Reinstalling of Sample database( AdventureWorks - OLTP) in SQL 2005

Hi All,
I was successfully installing sample database AdventureWork on my server the
first time, But realized that I didn't install with all the features with it
.
I delete the DB and try to reinstall it with all the features. it goes
through all the steps but DB don't install or attach. There isn't any error
messages.
I'm trying to install it so that I can use or test the Partition script that
come with it (PartitionAW.sql). Since I'm trying to partition my database.
How do I fix this problem or resolve it?
Thanks for your help.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200605/1I was able to reinstall Adventureworks Sample database using instawdb.sql bu
t
can't find PartitionAW.sql. The version of Sql2005 that I have is a
developer's version. I'm wandering if it doesn't come with the partitioning
script.
Does anyone knows how I can get this script to run or test it in Sql2005.
Thanks.
Naana wrote:
>Hi All,
>I was successfully installing sample database AdventureWork on my server th
e
>first time, But realized that I didn't install with all the features with i
t.
>I delete the DB and try to reinstall it with all the features. it goes
>through all the steps but DB don't install or attach. There isn't any error
>messages.
>I'm trying to install it so that I can use or test the Partition script tha
t
>come with it (PartitionAW.sql). Since I'm trying to partition my database.
>How do I fix this problem or resolve it?
>Thanks for your help.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200605/1

reindexing slow after installing SQL 2K SP4?

I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from SP3
to SP4, my re-indexing job takes 3-4 times longer than before. The amount
of data is about the same. Nothing else within SQL has changed. I am
running SQL on the other node, but the hardware is identical and I checked
the boot.ini (for enabling AWE) file and it's the same on boh boxes also.
Has anyone experienced this after installing Service Pack 4?There is an issue with AWE in SP4 - it stops using it. Get the post-SP4 hot
fix:
http://support.microsoft.com/kb/899761
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Nieves" <JuanN@.yahoo.com> wrote in message
news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from SP3
to SP4, my re-indexing job takes 3-4 times longer than before. The amount
of data is about the same. Nothing else within SQL has changed. I am
running SQL on the other node, but the hardware is identical and I checked
the boot.ini (for enabling AWE) file and it's the same on boh boxes also.
Has anyone experienced this after installing Service Pack 4?|||Thanks. I actually forgot to mention that I did install the Post SP 4
Hotfix rollup. My SQL Version is at 8.00.2187.
However, I did check Perfmon and SQL is using up more than 50% of the
physical memory, which I think, according to the article, means that it is
running normally.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> There is an issue with AWE in SP4 - it stops using it. Get the post-SP4
> hot
> fix:
> http://support.microsoft.com/kb/899761
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
> I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from
> SP3
> to SP4, my re-indexing job takes 3-4 times longer than before. The amount
> of data is about the same. Nothing else within SQL has changed. I am
> running SQL on the other node, but the hardware is identical and I checked
> the boot.ini (for enabling AWE) file and it's the same on boh boxes also.
> Has anyone experienced this after installing Service Pack 4?
>|||That's odd. How much RAM do you have on each node and let us know whether
the /3GB switch is/isn't used.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Nieves" <JuanN@.yahoo.com> wrote in message
news:OZ4SudcqGHA.2256@.TK2MSFTNGP03.phx.gbl...
Thanks. I actually forgot to mention that I did install the Post SP 4
Hotfix rollup. My SQL Version is at 8.00.2187.
However, I did check Perfmon and SQL is using up more than 50% of the
physical memory, which I think, according to the article, means that it is
running normally.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> There is an issue with AWE in SP4 - it stops using it. Get the post-SP4
> hot
> fix:
> http://support.microsoft.com/kb/899761
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
> I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from
> SP3
> to SP4, my re-indexing job takes 3-4 times longer than before. The amount
> of data is about the same. Nothing else within SQL has changed. I am
> running SQL on the other node, but the hardware is identical and I checked
> the boot.ini (for enabling AWE) file and it's the same on boh boxes also.
> Has anyone experienced this after installing Service Pack 4?
>|||Thanks,
There's 8 GB of RAM on each node. The 3/GB switch is not used and this was
actually PER Microsoft.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
> That's odd. How much RAM do you have on each node and let us know whether
> the /3GB switch is/isn't used.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:OZ4SudcqGHA.2256@.TK2MSFTNGP03.phx.gbl...
> Thanks. I actually forgot to mention that I did install the Post SP 4
> Hotfix rollup. My SQL Version is at 8.00.2187.
> However, I did check Perfmon and SQL is using up more than 50% of the
> physical memory, which I think, according to the article, means that it is
> running normally.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
>> There is an issue with AWE in SP4 - it stops using it. Get the post-SP4
>> hot
>> fix:
>> http://support.microsoft.com/kb/899761
>>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
>> I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from
>> SP3
>> to SP4, my re-indexing job takes 3-4 times longer than before. The
>> amount
>> of data is about the same. Nothing else within SQL has changed. I am
>> running SQL on the other node, but the hardware is identical and I
>> checked
>> the boot.ini (for enabling AWE) file and it's the same on boh boxes
>> also.
>> Has anyone experienced this after installing Service Pack 4?
>>
>|||Just wanted to sure. What's odd is that it appears to run differently on
each node. Also, of the 8 GB, how much did you tell it to use for SQL
Server? Could you give us the sp_configure output for max server memory and
AWE?
Are there other processes running on one node and not the other?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Nieves" <JuanN@.yahoo.com> wrote in message
news:%23$5lw3oqGHA.2108@.TK2MSFTNGP03.phx.gbl...
Thanks,
There's 8 GB of RAM on each node. The 3/GB switch is not used and this was
actually PER Microsoft.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
> That's odd. How much RAM do you have on each node and let us know whether
> the /3GB switch is/isn't used.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:OZ4SudcqGHA.2256@.TK2MSFTNGP03.phx.gbl...
> Thanks. I actually forgot to mention that I did install the Post SP 4
> Hotfix rollup. My SQL Version is at 8.00.2187.
> However, I did check Perfmon and SQL is using up more than 50% of the
> physical memory, which I think, according to the article, means that it is
> running normally.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
>> There is an issue with AWE in SP4 - it stops using it. Get the post-SP4
>> hot
>> fix:
>> http://support.microsoft.com/kb/899761
>>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
>> I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from
>> SP3
>> to SP4, my re-indexing job takes 3-4 times longer than before. The
>> amount
>> of data is about the same. Nothing else within SQL has changed. I am
>> running SQL on the other node, but the hardware is identical and I
>> checked
>> the boot.ini (for enabling AWE) file and it's the same on boh boxes
>> also.
>> Has anyone experienced this after installing Service Pack 4?
>>
>|||Thanks so much for your help Tom.
There are no processes running on one node that's not running on the other.
SQL Server is configured to use 6 GB - again, this was suggested by
microsoft when we were troubleshooting another problem several months back.
Here's the sp_configure output
max server memory (MB) 4 2147483647 6008
6008
awe enabled 0 1 1 1
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23Jp05DpqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> Just wanted to sure. What's odd is that it appears to run differently on
> each node. Also, of the 8 GB, how much did you tell it to use for SQL
> Server? Could you give us the sp_configure output for max server memory
> and
> AWE?
> Are there other processes running on one node and not the other?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:%23$5lw3oqGHA.2108@.TK2MSFTNGP03.phx.gbl...
> Thanks,
> There's 8 GB of RAM on each node. The 3/GB switch is not used and this
> was
> actually PER Microsoft.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
>> That's odd. How much RAM do you have on each node and let us know
>> whether
>> the /3GB switch is/isn't used.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OZ4SudcqGHA.2256@.TK2MSFTNGP03.phx.gbl...
>> Thanks. I actually forgot to mention that I did install the Post SP 4
>> Hotfix rollup. My SQL Version is at 8.00.2187.
>> However, I did check Perfmon and SQL is using up more than 50% of the
>> physical memory, which I think, according to the article, means that it
>> is
>> running normally.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
>> There is an issue with AWE in SP4 - it stops using it. Get the post-SP4
>> hot
>> fix:
>> http://support.microsoft.com/kb/899761
>>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
>> I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from
>> SP3
>> to SP4, my re-indexing job takes 3-4 times longer than before. The
>> amount
>> of data is about the same. Nothing else within SQL has changed. I am
>> running SQL on the other node, but the hardware is identical and I
>> checked
>> the boot.ini (for enabling AWE) file and it's the same on boh boxes
>> also.
>> Has anyone experienced this after installing Service Pack 4?
>>
>>
>|||If I were to increase the Max Memory, would I need to restart SQL service
for it to take effect?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23Jp05DpqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> Just wanted to sure. What's odd is that it appears to run differently on
> each node. Also, of the 8 GB, how much did you tell it to use for SQL
> Server? Could you give us the sp_configure output for max server memory
> and
> AWE?
> Are there other processes running on one node and not the other?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:%23$5lw3oqGHA.2108@.TK2MSFTNGP03.phx.gbl...
> Thanks,
> There's 8 GB of RAM on each node. The 3/GB switch is not used and this
> was
> actually PER Microsoft.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
>> That's odd. How much RAM do you have on each node and let us know
>> whether
>> the /3GB switch is/isn't used.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OZ4SudcqGHA.2256@.TK2MSFTNGP03.phx.gbl...
>> Thanks. I actually forgot to mention that I did install the Post SP 4
>> Hotfix rollup. My SQL Version is at 8.00.2187.
>> However, I did check Perfmon and SQL is using up more than 50% of the
>> physical memory, which I think, according to the article, means that it
>> is
>> running normally.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
>> There is an issue with AWE in SP4 - it stops using it. Get the post-SP4
>> hot
>> fix:
>> http://support.microsoft.com/kb/899761
>>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
>> I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from
>> SP3
>> to SP4, my re-indexing job takes 3-4 times longer than before. The
>> amount
>> of data is about the same. Nothing else within SQL has changed. I am
>> running SQL on the other node, but the hardware is identical and I
>> checked
>> the boot.ini (for enabling AWE) file and it's the same on boh boxes
>> also.
>> Has anyone experienced this after installing Service Pack 4?
>>
>>
>|||I just ran a perfmon and measured SQLServer:Memory Manager - Target Server
Memory and Total Server Memory. It's at a steady 5 GB. My Max memory is
set to 6 GB. Is this normal?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23Jp05DpqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> Just wanted to sure. What's odd is that it appears to run differently on
> each node. Also, of the 8 GB, how much did you tell it to use for SQL
> Server? Could you give us the sp_configure output for max server memory
> and
> AWE?
> Are there other processes running on one node and not the other?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:%23$5lw3oqGHA.2108@.TK2MSFTNGP03.phx.gbl...
> Thanks,
> There's 8 GB of RAM on each node. The 3/GB switch is not used and this
> was
> actually PER Microsoft.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
>> That's odd. How much RAM do you have on each node and let us know
>> whether
>> the /3GB switch is/isn't used.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OZ4SudcqGHA.2256@.TK2MSFTNGP03.phx.gbl...
>> Thanks. I actually forgot to mention that I did install the Post SP 4
>> Hotfix rollup. My SQL Version is at 8.00.2187.
>> However, I did check Perfmon and SQL is using up more than 50% of the
>> physical memory, which I think, according to the article, means that it
>> is
>> running normally.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
>> There is an issue with AWE in SP4 - it stops using it. Get the post-SP4
>> hot
>> fix:
>> http://support.microsoft.com/kb/899761
>>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
>> I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from
>> SP3
>> to SP4, my re-indexing job takes 3-4 times longer than before. The
>> amount
>> of data is about the same. Nothing else within SQL has changed. I am
>> running SQL on the other node, but the hardware is identical and I
>> checked
>> the boot.ini (for enabling AWE) file and it's the same on boh boxes
>> also.
>> Has anyone experienced this after installing Service Pack 4?
>>
>>
>|||6GB = 6,144MB, so you're just a little short of using the 6GB. Leaving the
remaining 2GB to the OS is plenty.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Nieves" <JuanN@.yahoo.com> wrote in message
news:OxSToz2qGHA.3564@.TK2MSFTNGP03.phx.gbl...
Thanks so much for your help Tom.
There are no processes running on one node that's not running on the other.
SQL Server is configured to use 6 GB - again, this was suggested by
microsoft when we were troubleshooting another problem several months back.
Here's the sp_configure output
max server memory (MB) 4 2147483647 6008
6008
awe enabled 0 1 1 1
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23Jp05DpqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> Just wanted to sure. What's odd is that it appears to run differently on
> each node. Also, of the 8 GB, how much did you tell it to use for SQL
> Server? Could you give us the sp_configure output for max server memory
> and
> AWE?
> Are there other processes running on one node and not the other?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:%23$5lw3oqGHA.2108@.TK2MSFTNGP03.phx.gbl...
> Thanks,
> There's 8 GB of RAM on each node. The 3/GB switch is not used and this
> was
> actually PER Microsoft.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
>> That's odd. How much RAM do you have on each node and let us know
>> whether
>> the /3GB switch is/isn't used.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OZ4SudcqGHA.2256@.TK2MSFTNGP03.phx.gbl...
>> Thanks. I actually forgot to mention that I did install the Post SP 4
>> Hotfix rollup. My SQL Version is at 8.00.2187.
>> However, I did check Perfmon and SQL is using up more than 50% of the
>> physical memory, which I think, according to the article, means that it
>> is
>> running normally.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
>> There is an issue with AWE in SP4 - it stops using it. Get the post-SP4
>> hot
>> fix:
>> http://support.microsoft.com/kb/899761
>>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
>> I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from
>> SP3
>> to SP4, my re-indexing job takes 3-4 times longer than before. The
>> amount
>> of data is about the same. Nothing else within SQL has changed. I am
>> running SQL on the other node, but the hardware is identical and I
>> checked
>> the boot.ini (for enabling AWE) file and it's the same on boh boxes
>> also.
>> Has anyone experienced this after installing Service Pack 4?
>>
>>
>|||If you were using AWE, yes.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Nieves" <JuanN@.yahoo.com> wrote in message
news:enizG02qGHA.2180@.TK2MSFTNGP05.phx.gbl...
If I were to increase the Max Memory, would I need to restart SQL service
for it to take effect?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23Jp05DpqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> Just wanted to sure. What's odd is that it appears to run differently on
> each node. Also, of the 8 GB, how much did you tell it to use for SQL
> Server? Could you give us the sp_configure output for max server memory
> and
> AWE?
> Are there other processes running on one node and not the other?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:%23$5lw3oqGHA.2108@.TK2MSFTNGP03.phx.gbl...
> Thanks,
> There's 8 GB of RAM on each node. The 3/GB switch is not used and this
> was
> actually PER Microsoft.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
>> That's odd. How much RAM do you have on each node and let us know
>> whether
>> the /3GB switch is/isn't used.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OZ4SudcqGHA.2256@.TK2MSFTNGP03.phx.gbl...
>> Thanks. I actually forgot to mention that I did install the Post SP 4
>> Hotfix rollup. My SQL Version is at 8.00.2187.
>> However, I did check Perfmon and SQL is using up more than 50% of the
>> physical memory, which I think, according to the article, means that it
>> is
>> running normally.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
>> There is an issue with AWE in SP4 - it stops using it. Get the post-SP4
>> hot
>> fix:
>> http://support.microsoft.com/kb/899761
>>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
>> I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from
>> SP3
>> to SP4, my re-indexing job takes 3-4 times longer than before. The
>> amount
>> of data is about the same. Nothing else within SQL has changed. I am
>> running SQL on the other node, but the hardware is identical and I
>> checked
>> the boot.ini (for enabling AWE) file and it's the same on boh boxes
>> also.
>> Has anyone experienced this after installing Service Pack 4?
>>
>>
>|||Your max server memory should be at 6 GB = 6,144 MB. Not sure why it's
below that. The only other thing I can think of is that you may have a
Windows hotfix that was applied to one box and not the other.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Nieves" <JuanN@.yahoo.com> wrote in message
news:ea$m452qGHA.4864@.TK2MSFTNGP03.phx.gbl...
I just ran a perfmon and measured SQLServer:Memory Manager - Target Server
Memory and Total Server Memory. It's at a steady 5 GB. My Max memory is
set to 6 GB. Is this normal?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23Jp05DpqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> Just wanted to sure. What's odd is that it appears to run differently on
> each node. Also, of the 8 GB, how much did you tell it to use for SQL
> Server? Could you give us the sp_configure output for max server memory
> and
> AWE?
> Are there other processes running on one node and not the other?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:%23$5lw3oqGHA.2108@.TK2MSFTNGP03.phx.gbl...
> Thanks,
> There's 8 GB of RAM on each node. The 3/GB switch is not used and this
> was
> actually PER Microsoft.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
>> That's odd. How much RAM do you have on each node and let us know
>> whether
>> the /3GB switch is/isn't used.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OZ4SudcqGHA.2256@.TK2MSFTNGP03.phx.gbl...
>> Thanks. I actually forgot to mention that I did install the Post SP 4
>> Hotfix rollup. My SQL Version is at 8.00.2187.
>> However, I did check Perfmon and SQL is using up more than 50% of the
>> physical memory, which I think, according to the article, means that it
>> is
>> running normally.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
>> There is an issue with AWE in SP4 - it stops using it. Get the post-SP4
>> hot
>> fix:
>> http://support.microsoft.com/kb/899761
>>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Nieves" <JuanN@.yahoo.com> wrote in message
>> news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
>> I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from
>> SP3
>> to SP4, my re-indexing job takes 3-4 times longer than before. The
>> amount
>> of data is about the same. Nothing else within SQL has changed. I am
>> running SQL on the other node, but the hardware is identical and I
>> checked
>> the boot.ini (for enabling AWE) file and it's the same on boh boxes
>> also.
>> Has anyone experienced this after installing Service Pack 4?
>>
>>
>

reindexing slow after installing SQL 2K SP4?

I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from SP3
to SP4, my re-indexing job takes 3-4 times longer than before. The amount
of data is about the same. Nothing else within SQL has changed. I am
running SQL on the other node, but the hardware is identical and I checked
the boot.ini (for enabling AWE) file and it's the same on boh boxes also.
Has anyone experienced this after installing Service Pack 4?There is an issue with AWE in SP4 - it stops using it. Get the post-SP4 hot
fix:
http://support.microsoft.com/kb/899761
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Nieves" <JuanN@.yahoo.com> wrote in message
news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from SP3
to SP4, my re-indexing job takes 3-4 times longer than before. The amount
of data is about the same. Nothing else within SQL has changed. I am
running SQL on the other node, but the hardware is identical and I checked
the boot.ini (for enabling AWE) file and it's the same on boh boxes also.
Has anyone experienced this after installing Service Pack 4?|||Thanks. I actually forgot to mention that I did install the Post SP 4
Hotfix rollup. My SQL Version is at 8.00.2187.
However, I did check Perfmon and SQL is using up more than 50% of the
physical memory, which I think, according to the article, means that it is
running normally.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> There is an issue with AWE in SP4 - it stops using it. Get the post-SP4
> hot
> fix:
> http://support.microsoft.com/kb/899761
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
> I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from
> SP3
> to SP4, my re-indexing job takes 3-4 times longer than before. The amount
> of data is about the same. Nothing else within SQL has changed. I am
> running SQL on the other node, but the hardware is identical and I checked
> the boot.ini (for enabling AWE) file and it's the same on boh boxes also.
> Has anyone experienced this after installing Service Pack 4?
>|||That's odd. How much RAM do you have on each node and let us know whether
the /3GB switch is/isn't used.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Nieves" <JuanN@.yahoo.com> wrote in message
news:OZ4SudcqGHA.2256@.TK2MSFTNGP03.phx.gbl...
Thanks. I actually forgot to mention that I did install the Post SP 4
Hotfix rollup. My SQL Version is at 8.00.2187.
However, I did check Perfmon and SQL is using up more than 50% of the
physical memory, which I think, according to the article, means that it is
running normally.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> There is an issue with AWE in SP4 - it stops using it. Get the post-SP4
> hot
> fix:
> http://support.microsoft.com/kb/899761
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:OYQCGUbqGHA.928@.TK2MSFTNGP04.phx.gbl...
> I'm using SQL 2000 Enterprise Edition (Clustered). After upgrading from
> SP3
> to SP4, my re-indexing job takes 3-4 times longer than before. The amount
> of data is about the same. Nothing else within SQL has changed. I am
> running SQL on the other node, but the hardware is identical and I checked
> the boot.ini (for enabling AWE) file and it's the same on boh boxes also.
> Has anyone experienced this after installing Service Pack 4?
>|||Thanks,
There's 8 GB of RAM on each node. The 3/GB switch is not used and this was
actually PER Microsoft.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
> That's odd. How much RAM do you have on each node and let us know whether
> the /3GB switch is/isn't used.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:OZ4SudcqGHA.2256@.TK2MSFTNGP03.phx.gbl...
> Thanks. I actually forgot to mention that I did install the Post SP 4
> Hotfix rollup. My SQL Version is at 8.00.2187.
> However, I did check Perfmon and SQL is using up more than 50% of the
> physical memory, which I think, according to the article, means that it is
> running normally.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
>|||Just wanted to sure. What's odd is that it appears to run differently on
each node. Also, of the 8 GB, how much did you tell it to use for SQL
Server? Could you give us the sp_configure output for max server memory and
AWE?
Are there other processes running on one node and not the other?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Nieves" <JuanN@.yahoo.com> wrote in message
news:%23$5lw3oqGHA.2108@.TK2MSFTNGP03.phx.gbl...
Thanks,
There's 8 GB of RAM on each node. The 3/GB switch is not used and this was
actually PER Microsoft.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
> That's odd. How much RAM do you have on each node and let us know whether
> the /3GB switch is/isn't used.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:OZ4SudcqGHA.2256@.TK2MSFTNGP03.phx.gbl...
> Thanks. I actually forgot to mention that I did install the Post SP 4
> Hotfix rollup. My SQL Version is at 8.00.2187.
> However, I did check Perfmon and SQL is using up more than 50% of the
> physical memory, which I think, according to the article, means that it is
> running normally.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:ux$ot8bqGHA.4032@.TK2MSFTNGP03.phx.gbl...
>|||Thanks so much for your help Tom.
There are no processes running on one node that's not running on the other.
SQL Server is configured to use 6 GB - again, this was suggested by
microsoft when we were troubleshooting another problem several months back.
Here's the sp_configure output
max server memory (MB) 4 2147483647 6008
6008
awe enabled 0 1 1 1
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23Jp05DpqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> Just wanted to sure. What's odd is that it appears to run differently on
> each node. Also, of the 8 GB, how much did you tell it to use for SQL
> Server? Could you give us the sp_configure output for max server memory
> and
> AWE?
> Are there other processes running on one node and not the other?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:%23$5lw3oqGHA.2108@.TK2MSFTNGP03.phx.gbl...
> Thanks,
> There's 8 GB of RAM on each node. The 3/GB switch is not used and this
> was
> actually PER Microsoft.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
>|||If I were to increase the Max Memory, would I need to restart SQL service
for it to take effect?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23Jp05DpqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> Just wanted to sure. What's odd is that it appears to run differently on
> each node. Also, of the 8 GB, how much did you tell it to use for SQL
> Server? Could you give us the sp_configure output for max server memory
> and
> AWE?
> Are there other processes running on one node and not the other?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:%23$5lw3oqGHA.2108@.TK2MSFTNGP03.phx.gbl...
> Thanks,
> There's 8 GB of RAM on each node. The 3/GB switch is not used and this
> was
> actually PER Microsoft.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
>|||I just ran a perfmon and measured SQLServer:Memory Manager - Target Server
Memory and Total Server Memory. It's at a steady 5 GB. My Max memory is
set to 6 GB. Is this normal?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23Jp05DpqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> Just wanted to sure. What's odd is that it appears to run differently on
> each node. Also, of the 8 GB, how much did you tell it to use for SQL
> Server? Could you give us the sp_configure output for max server memory
> and
> AWE?
> Are there other processes running on one node and not the other?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:%23$5lw3oqGHA.2108@.TK2MSFTNGP03.phx.gbl...
> Thanks,
> There's 8 GB of RAM on each node. The 3/GB switch is not used and this
> was
> actually PER Microsoft.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
>|||6GB = 6,144MB, so you're just a little short of using the 6GB. Leaving the
remaining 2GB to the OS is plenty.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Nieves" <JuanN@.yahoo.com> wrote in message
news:OxSToz2qGHA.3564@.TK2MSFTNGP03.phx.gbl...
Thanks so much for your help Tom.
There are no processes running on one node that's not running on the other.
SQL Server is configured to use 6 GB - again, this was suggested by
microsoft when we were troubleshooting another problem several months back.
Here's the sp_configure output
max server memory (MB) 4 2147483647 6008
6008
awe enabled 0 1 1 1
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23Jp05DpqGHA.4032@.TK2MSFTNGP03.phx.gbl...
> Just wanted to sure. What's odd is that it appears to run differently on
> each node. Also, of the 8 GB, how much did you tell it to use for SQL
> Server? Could you give us the sp_configure output for max server memory
> and
> AWE?
> Are there other processes running on one node and not the other?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:%23$5lw3oqGHA.2108@.TK2MSFTNGP03.phx.gbl...
> Thanks,
> There's 8 GB of RAM on each node. The 3/GB switch is not used and this
> was
> actually PER Microsoft.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:euOlQmcqGHA.4992@.TK2MSFTNGP05.phx.gbl...
>

Registry key setting for MS SQL Server

I am installing my application thru Installshield Professional 5. How
to know whether MS SQL Server is installed or not on the machine on
which i am installing my application. What is the registry key thru
which we can find this."harish" <harishksh@.yahoo.com> wrote in message
news:ff46df6e.0401090401.732c0ecb@.posting.google.c om...
> I am installing my application thru Installshield Professional 5. How
> to know whether MS SQL Server is installed or not on the machine on
> which i am installing my application. What is the registry key thru
> which we can find this.

Have a look at points 12 and 13 in this KB article:

http://support.microsoft.com/defaul...6&Product=sql2k

Simon