Few Issues

I am sorry to put so many issues at one go.
1. I have just upgraded one of our production dbs(sql 2000) with
latest service packs( change from 3 to 4) and others hot fixes.Also
upgraded the 2003 WIN2k box with all the hot fixes. Since after,all my
processing is taking almost double time to complete.We have processings
which runs thrice a day , which pulls/massages data from our central
db.I did identify few store procs which are running very slowly.My
question.
a)Did any one face this issue before , and if yes, could anyone list
where all it could have got affected?
b) What all non-db related things i should be looking at?
2.I have a sqlserver(2000) box( win 2k3) with 8GB of RAM. I abe
configured it to use 6GB of RAM through dynamic memory management.I
have also enabled the AWE option. My question is do i stil have to
include /pae switch in the boot.ini file.3GB /PAE switch comes into
picture when i have 4 GB of RAM(certain versions) , and it gives me
that extra 1 GB. BUt when i have 8GB , it is AWE Enabled , then what
extra benefit do i get by adding this switch? Does AWE depends on PAE
switch to fucntion normally. AWE infact takes all the memory space
(except 128 MB for OS to work).SO why do i add 3GB /PAE switch to tell
OS to give me 1 extra GB more when AWE( it takes the entire memory and
not just only 1 GB more does that for me.
3. How do i know when was the last time my index was rebuilt/updated.(
may be recreate or may be using dbccreindex).i tried DBCC show update
statiscs, it does show something called last updated. What i know this
shows, when the statistics were last updated( mine is auto update).So
if i run dbcc reindex will the last updated value changeFor future posts, you might want to post each Q independently, to keep each topic in a separate
thread. :-)
2) AWE depends on OS AWE. It is a no-op to sp_configure AWE without setting PAE in BOOT.INI. You can
still decide whether to have 2 or 3 GB "normally" addressable memory using the /3GB switch. The
recommendation is not to have /3GB if you have > some 12-16GB memory in the machine (as overhead of
managing that amount of memory comes from what is left from 4GB minus 2 or 3 GB).
3) That information is not stored anywhere. Why is it important to you?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<shuvam_roy@.yahoo.com> wrote in message news:1127221805.482833.46720@.g49g2000cwa.googlegroups.com...
>I am sorry to put so many issues at one go.
> 1. I have just upgraded one of our production dbs(sql 2000) with
> latest service packs( change from 3 to 4) and others hot fixes.Also
> upgraded the 2003 WIN2k box with all the hot fixes. Since after,all my
> processing is taking almost double time to complete.We have processings
> which runs thrice a day , which pulls/massages data from our central
> db.I did identify few store procs which are running very slowly.My
> question.
> a)Did any one face this issue before , and if yes, could anyone list
> where all it could have got affected?
> b) What all non-db related things i should be looking at?
> 2.I have a sqlserver(2000) box( win 2k3) with 8GB of RAM. I abe
> configured it to use 6GB of RAM through dynamic memory management.I
> have also enabled the AWE option. My question is do i stil have to
> include /pae switch in the boot.ini file.3GB /PAE switch comes into
> picture when i have 4 GB of RAM(certain versions) , and it gives me
> that extra 1 GB. BUt when i have 8GB , it is AWE Enabled , then what
> extra benefit do i get by adding this switch? Does AWE depends on PAE
> switch to fucntion normally. AWE infact takes all the memory space
> (except 128 MB for OS to work).SO why do i add 3GB /PAE switch to tell
> OS to give me 1 extra GB more when AWE( it takes the entire memory and
> not just only 1 GB more does that for me.
>
> 3. How do i know when was the last time my index was rebuilt/updated.(
> may be recreate or may be using dbccreindex).i tried DBCC show update
> statiscs, it does show something called last updated. What i know this
> shows, when the statistics were last updated( mine is auto update).So
> if i run dbcc reindex will the last updated value change
>|||Thanks a lot TIBOR...next tiem will post different questions on
different threads.
BTW any idea baout the first one.?|||You're welcome... :-)
As for the first one, I can't say. My first guess would be to check the execution plans for the
queries involved...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<shuvam_roy@.yahoo.com> wrote in message
news:1127229172.480279.256450@.g49g2000cwa.googlegroups.com...
> Thanks a lot TIBOR...next tiem will post different questions on
> different threads.
> BTW any idea baout the first one.?
>

Few Issues

I am sorry to put so many issues at one go.
1. I have just upgraded one of our production dbs(sql 2000) with
latest service packs( change from 3 to 4) and others hot fixes.Also
upgraded the 2003 WIN2k box with all the hot fixes. Since after,all my
processing is taking almost double time to complete.We have processings
which runs thrice a day , which pulls/massages data from our central
db.I did identify few store procs which are running very slowly.My
question.
a)Did any one face this issue before , and if yes, could anyone list
where all it could have got affected?
b) What all non-db related things i should be looking at?
2.I have a sqlserver(2000) box( win 2k3) with 8GB of RAM. I abe
configured it to use 6GB of RAM through dynamic memory management.I
have also enabled the AWE option. My question is do i stil have to
include /pae switch in the boot.ini file.3GB /PAE switch comes into
picture when i have 4 GB of RAM(certain versions) , and it gives me
that extra 1 GB. BUt when i have 8GB , it is AWE Enabled , then what
extra benefit do i get by adding this switch? Does AWE depends on PAE
switch to fucntion normally. AWE infact takes all the memory space
(except 128 MB for OS to work).SO why do i add 3GB /PAE switch to tell
OS to give me 1 extra GB more when AWE( it takes the entire memory and
not just only 1 GB more does that for me.
3. How do i know when was the last time my index was rebuilt/updated.(
may be recreate or may be using dbccreindex).i tried DBCC show update
statiscs, it does show something called last updated. What i know this
shows, when the statistics were last updated( mine is auto update).So
if i run dbcc reindex will the last updated value change
For future posts, you might want to post each Q independently, to keep each topic in a separate
thread. :-)
2) AWE depends on OS AWE. It is a no-op to sp_configure AWE without setting PAE in BOOT.INI. You can
still decide whether to have 2 or 3 GB "normally" addressable memory using the /3GB switch. The
recommendation is not to have /3GB if you have > some 12-16GB memory in the machine (as overhead of
managing that amount of memory comes from what is left from 4GB minus 2 or 3 GB).
3) That information is not stored anywhere. Why is it important to you?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<shuvam_roy@.yahoo.com> wrote in message news:1127221805.482833.46720@.g49g2000cwa.googlegro ups.com...
>I am sorry to put so many issues at one go.
> 1. I have just upgraded one of our production dbs(sql 2000) with
> latest service packs( change from 3 to 4) and others hot fixes.Also
> upgraded the 2003 WIN2k box with all the hot fixes. Since after,all my
> processing is taking almost double time to complete.We have processings
> which runs thrice a day , which pulls/massages data from our central
> db.I did identify few store procs which are running very slowly.My
> question.
> a)Did any one face this issue before , and if yes, could anyone list
> where all it could have got affected?
> b) What all non-db related things i should be looking at?
> 2.I have a sqlserver(2000) box( win 2k3) with 8GB of RAM. I abe
> configured it to use 6GB of RAM through dynamic memory management.I
> have also enabled the AWE option. My question is do i stil have to
> include /pae switch in the boot.ini file.3GB /PAE switch comes into
> picture when i have 4 GB of RAM(certain versions) , and it gives me
> that extra 1 GB. BUt when i have 8GB , it is AWE Enabled , then what
> extra benefit do i get by adding this switch? Does AWE depends on PAE
> switch to fucntion normally. AWE infact takes all the memory space
> (except 128 MB for OS to work).SO why do i add 3GB /PAE switch to tell
> OS to give me 1 extra GB more when AWE( it takes the entire memory and
> not just only 1 GB more does that for me.
>
> 3. How do i know when was the last time my index was rebuilt/updated.(
> may be recreate or may be using dbccreindex).i tried DBCC show update
> statiscs, it does show something called last updated. What i know this
> shows, when the statistics were last updated( mine is auto update).So
> if i run dbcc reindex will the last updated value change
>
|||Thanks a lot TIBOR...next tiem will post different questions on
different threads.
BTW any idea baout the first one.?
|||You're welcome... :-)
As for the first one, I can't say. My first guess would be to check the execution plans for the
queries involved...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<shuvam_roy@.yahoo.com> wrote in message
news:1127229172.480279.256450@.g49g2000cwa.googlegr oups.com...
> Thanks a lot TIBOR...next tiem will post different questions on
> different threads.
> BTW any idea baout the first one.?
>

Few Issues

I am sorry to put so many issues at one go.
1. I have just upgraded one of our production dbs(sql 2000) with
latest service packs( change from 3 to 4) and others hot fixes.Also
upgraded the 2003 WIN2k box with all the hot fixes. Since after,all my
processing is taking almost double time to complete.We have processings
which runs thrice a day , which pulls/massages data from our central
db.I did identify few store procs which are running very slowly.My
question.
a)Did any one face this issue before , and if yes, could anyone list
where all it could have got affected?
b) What all non-db related things i should be looking at?
2.I have a sqlserver(2000) box( win 2k3) with 8GB of RAM. I abe
configured it to use 6GB of RAM through dynamic memory management.I
have also enabled the AWE option. My question is do i stil have to
include /pae switch in the boot.ini file.3GB /PAE switch comes into
picture when i have 4 GB of RAM(certain versions) , and it gives me
that extra 1 GB. BUt when i have 8GB , it is AWE Enabled , then what
extra benefit do i get by adding this switch? Does AWE depends on PAE
switch to fucntion normally. AWE infact takes all the memory space
(except 128 MB for OS to work).SO why do i add 3GB /PAE switch to tell
OS to give me 1 extra GB more when AWE( it takes the entire memory and
not just only 1 GB more does that for me.
3. How do i know when was the last time my index was rebuilt/updated.(
may be recreate or may be using dbccreindex).i tried DBCC show update
statiscs, it does show something called last updated. What i know this
shows, when the statistics were last updated( mine is auto update).So
if i run dbcc reindex will the last updated value changeFor future posts, you might want to post each Q independently, to keep each
topic in a separate
thread. :-)
2) AWE depends on OS AWE. It is a no-op to sp_configure AWE without setting
PAE in BOOT.INI. You can
still decide whether to have 2 or 3 GB "normally" addressable memory using t
he /3GB switch. The
recommendation is not to have /3GB if you have > some 12-16GB memory in the
machine (as overhead of
managing that amount of memory comes from what is left from 4GB minus 2 or 3
GB).
3) That information is not stored anywhere. Why is it important to you?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<shuvam_roy@.yahoo.com> wrote in message news:1127221805.482833.46720@.g49g2000cwa.googlegroup
s.com...
>I am sorry to put so many issues at one go.
> 1. I have just upgraded one of our production dbs(sql 2000) with
> latest service packs( change from 3 to 4) and others hot fixes.Also
> upgraded the 2003 WIN2k box with all the hot fixes. Since after,all my
> processing is taking almost double time to complete.We have processings
> which runs thrice a day , which pulls/massages data from our central
> db.I did identify few store procs which are running very slowly.My
> question.
> a)Did any one face this issue before , and if yes, could anyone list
> where all it could have got affected?
> b) What all non-db related things i should be looking at?
> 2.I have a sqlserver(2000) box( win 2k3) with 8GB of RAM. I abe
> configured it to use 6GB of RAM through dynamic memory management.I
> have also enabled the AWE option. My question is do i stil have to
> include /pae switch in the boot.ini file.3GB /PAE switch comes into
> picture when i have 4 GB of RAM(certain versions) , and it gives me
> that extra 1 GB. BUt when i have 8GB , it is AWE Enabled , then what
> extra benefit do i get by adding this switch? Does AWE depends on PAE
> switch to fucntion normally. AWE infact takes all the memory space
> (except 128 MB for OS to work).SO why do i add 3GB /PAE switch to tell
> OS to give me 1 extra GB more when AWE( it takes the entire memory and
> not just only 1 GB more does that for me.
>
> 3. How do i know when was the last time my index was rebuilt/updated.(
> may be recreate or may be using dbccreindex).i tried DBCC show update
> statiscs, it does show something called last updated. What i know this
> shows, when the statistics were last updated( mine is auto update).So
> if i run dbcc reindex will the last updated value change
>|||Thanks a lot TIBOR...next tiem will post different questions on
different threads.
BTW any idea baout the first one.?|||You're welcome... :-)
As for the first one, I can't say. My first guess would be to check the exec
ution plans for the
queries involved...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<shuvam_roy@.yahoo.com> wrote in message
news:1127229172.480279.256450@.g49g2000cwa.googlegroups.com...
> Thanks a lot TIBOR...next tiem will post different questions on
> different threads.
> BTW any idea baout the first one.?
>sql

feature?

I was setting up a new SQL 2005 sp2 (x64) box and restoring dbs. I restored
DB1, then moved on to DB2. I was restoring from a file, so I added the
file, forgot to change the db name in the dropdown, so it still said DB1,
changed the file paths, and clicked ok. So of course when I clicked ok and
it started the restore, I got an error telling me the file contained a db
other than DB1. Realizing my mistake, I then selected DB2 from the
dropdown, and clicked ok. The db restored just fine, but the message I got
at the end told me that DB1 had been restored...when in fact it was DB2 that
was restored.
AndreAndre wrote:
> I was setting up a new SQL 2005 sp2 (x64) box and restoring dbs. I restor
ed
> DB1, then moved on to DB2. I was restoring from a file, so I added the
> file, forgot to change the db name in the dropdown, so it still said DB1,
> changed the file paths, and clicked ok. So of course when I clicked ok an
d
> it started the restore, I got an error telling me the file contained a db
> other than DB1. Realizing my mistake, I then selected DB2 from the
> dropdown, and clicked ok. The db restored just fine, but the message I go
t
> at the end told me that DB1 had been restored...when in fact it was DB2 th
at
> was restored.
> Andre
>
I think it's just a matter of a missing "refresh" of the GUI. I'm not
using the GUI for restores myself so I'm not familiar with how it
appears, but you can be quite sure that it is DB2 you've restored - and
not DB1. You'd only be able to restore DB2 on top of DB1 if you explicit
had told it to replace the database.
Regards
Steen Schlter Persson
Database Administrator / System Administrator

feature?

I was setting up a new SQL 2005 sp2 (x64) box and restoring dbs. I restored
DB1, then moved on to DB2. I was restoring from a file, so I added the
file, forgot to change the db name in the dropdown, so it still said DB1,
changed the file paths, and clicked ok. So of course when I clicked ok and
it started the restore, I got an error telling me the file contained a db
other than DB1. Realizing my mistake, I then selected DB2 from the
dropdown, and clicked ok. The db restored just fine, but the message I got
at the end told me that DB1 had been restored...when in fact it was DB2 that
was restored.
Andre
Andre wrote:
> I was setting up a new SQL 2005 sp2 (x64) box and restoring dbs. I restored
> DB1, then moved on to DB2. I was restoring from a file, so I added the
> file, forgot to change the db name in the dropdown, so it still said DB1,
> changed the file paths, and clicked ok. So of course when I clicked ok and
> it started the restore, I got an error telling me the file contained a db
> other than DB1. Realizing my mistake, I then selected DB2 from the
> dropdown, and clicked ok. The db restored just fine, but the message I got
> at the end told me that DB1 had been restored...when in fact it was DB2 that
> was restored.
> Andre
>
I think it's just a matter of a missing "refresh" of the GUI. I'm not
using the GUI for restores myself so I'm not familiar with how it
appears, but you can be quite sure that it is DB2 you've restored - and
not DB1. You'd only be able to restore DB2 on top of DB1 if you explicit
had told it to replace the database.
Regards
Steen Schlter Persson
Database Administrator / System Administrator

feature?

I was setting up a new SQL 2005 sp2 (x64) box and restoring dbs. I restored
DB1, then moved on to DB2. I was restoring from a file, so I added the
file, forgot to change the db name in the dropdown, so it still said DB1,
changed the file paths, and clicked ok. So of course when I clicked ok and
it started the restore, I got an error telling me the file contained a db
other than DB1. Realizing my mistake, I then selected DB2 from the
dropdown, and clicked ok. The db restored just fine, but the message I got
at the end told me that DB1 had been restored...when in fact it was DB2 that
was restored.
AndreAndre wrote:
> I was setting up a new SQL 2005 sp2 (x64) box and restoring dbs. I restored
> DB1, then moved on to DB2. I was restoring from a file, so I added the
> file, forgot to change the db name in the dropdown, so it still said DB1,
> changed the file paths, and clicked ok. So of course when I clicked ok and
> it started the restore, I got an error telling me the file contained a db
> other than DB1. Realizing my mistake, I then selected DB2 from the
> dropdown, and clicked ok. The db restored just fine, but the message I got
> at the end told me that DB1 had been restored...when in fact it was DB2 that
> was restored.
> Andre
>
I think it's just a matter of a missing "refresh" of the GUI. I'm not
using the GUI for restores myself so I'm not familiar with how it
appears, but you can be quite sure that it is DB2 you've restored - and
not DB1. You'd only be able to restore DB2 on top of DB1 if you explicit
had told it to replace the database.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator