Reindexing has different behaviour in 2005

I noticed that when I use Maintenace plan wizard to create maintenance plan
to reindex a database, it runs different than it did on SQL2000.
On SQL2000, the job was running about 15 minutes on my 10GB database. During
that time there was a lot of disk activity (loging) and CPU was around 30%.
Now on SQL2005 if I run reindexing maintenance plan on the same 10 GB
database, it first utilizes CPU to maximum (one thread on hyper-threaded
CPU - 3.4GHz Xeon) and during that time there is no disk activity at all.
Profiler tells me that it selects data about database schema. That runs
about 30 minutes and after that actual reindexing begins that also couses a
lot of disk activity and lasts about 15 minutes (same as on SQL2000).
I'm a bit confused about that first 30 minutes when only CPU is doing all
the work. That part was not there in SQL2000. If it takes 30 minutes on 10GB
database, what will happen on 100GB or larger databases? Has anyone some
info if that behaviour has changed in SQL2005?
TomCan you tell us what command(s) the mp is running? You should be able to
script it out.
"Tom" wrote:

> I noticed that when I use Maintenace plan wizard to create maintenance pla
n
> to reindex a database, it runs different than it did on SQL2000.
> On SQL2000, the job was running about 15 minutes on my 10GB database. Duri
ng
> that time there was a lot of disk activity (loging) and CPU was around 30%
.
> Now on SQL2005 if I run reindexing maintenance plan on the same 10 GB
> database, it first utilizes CPU to maximum (one thread on hyper-threaded
> CPU - 3.4GHz Xeon) and during that time there is no disk activity at all.
> Profiler tells me that it selects data about database schema. That runs
> about 30 minutes and after that actual reindexing begins that also couses
a
> lot of disk activity and lasts about 15 minutes (same as on SQL2000).
> I'm a bit confused about that first 30 minutes when only CPU is doing all
> the work. That part was not there in SQL2000. If it takes 30 minutes on 10
GB
> database, what will happen on 100GB or larger databases? Has anyone some
> info if that behaviour has changed in SQL2005?
> Tom
>
>

Register server wizard malfunction

Hi,
I installed sql server 2000 enterprise edition on windows 2000 advanced server undera domain account that had the sys admin privileges. However i logged in with my domain account and installed the sql server on a remote machine.The installation completed
successfully. i have also set the 'sa' p/w. Now when i go into the log lifes for sqlserveragent, i see an error like 'data area is less than...' and also it is showing that the sql server is running in single user mode. Also when i opened the enterprise
manager i am able to see the <local> server but when i try to register a new server, the wizard after the initial screen is getting disabled and is closing the entire enterprise manager window. Except for the regiser sql server wizard, all the other wizar
ds are working fine, i am able to setup replication etc.
I would hate to uninstall and reinstall, is their any way to correct the installtion?
Also, the domain a/c that is used by sql server will not allow me to do a remote destop connection(some corporate agreement), hence i have to login with my own domain a/c. Also i have done the default 1433 port installation.
1. Please check the sqlstp.log to make sure that sql server was properly
installed. You'll find this file in your WinNT folder.
2. About uninstalling SQL Server, the best would be trhough Control panel,
Add-Remove Programs. Should that fail, please refer to
290991 HOW TO: Manually remove SQL Server 2000 default, named, or virtual
http://support.microsoft.com/?id=290991
Thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Register server wizard malfunction

Hi,
I installed sql server 2000 enterprise edition on Windows 2000 advanced serv
er undera domain account that had the sys admin privileges. However i logged
in with my domain account and installed the sql server on a remote machine.
The installation completed
successfully. i have also set the 'sa' p/w. Now when i go into the log lifes
for sqlserveragent, i see an error like 'data area is less than...' and al
so it is showing that the sql server is running in single user mode. Also wh
en i opened the enterprise
manager i am able to see the <local> server but when i try to register a new
server, the wizard after the initial screen is getting disabled and is clos
ing the entire enterprise manager window. Except for the regiser sql server
wizard, all the other wizar
ds are working fine, i am able to setup replication etc.
I would hate to uninstall and reinstall, is their any way to correct the ins
talltion?
Also, the domain a/c that is used by sql server will not allow me to do a re
mote destop connection(some corporate agreement), hence i have to login with
my own domain a/c. Also i have done the default 1433 port installation.1. Please check the sqlstp.log to make sure that sql server was properly
installed. You'll find this file in your WinNT folder.
2. About uninstalling SQL Server, the best would be trhough Control panel,
Add-Remove Programs. Should that fail, please refer to
290991 HOW TO: Manually remove SQL Server 2000 default, named, or virtual
http://support.microsoft.com/?id=290991
Thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Register server wizard malfunction

Hi,
I installed sql server 2000 enterprise edition on windows 2000 advanced server undera domain account that had the sys admin privileges. However i logged in with my domain account and installed the sql server on a remote machine.The installation completed successfully. i have also set the 'sa' p/w. Now when i go into the log lifes for sqlserveragent, i see an error like 'data area is less than...' and also it is showing that the sql server is running in single user mode. Also when i opened the enterprise manager i am able to see the <local> server but when i try to register a new server, the wizard after the initial screen is getting disabled and is closing the entire enterprise manager window. Except for the regiser sql server wizard, all the other wizards are working fine, i am able to setup replication etc.
I would hate to uninstall and reinstall, is their any way to correct the installtion?
Also, the domain a/c that is used by sql server will not allow me to do a remote destop connection(some corporate agreement), hence i have to login with my own domain a/c. Also i have done the default 1433 port installation.1. Please check the sqlstp.log to make sure that sql server was properly
installed. You'll find this file in your WinNT folder.
2. About uninstalling SQL Server, the best would be trhough Control panel,
Add-Remove Programs. Should that fail, please refer to
290991 HOW TO: Manually remove SQL Server 2000 default, named, or virtual
http://support.microsoft.com/?id=290991
Thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.