Wednesday, September 28, 2005

Transaction Log space for DBCC DBREINDEX

1.The log space required by DBCC DBREINDEX is roughly equivalent to the number of index pages multiplied by 8 KB.

2. You can use DBCC SHOWCONTIG to determine the number of pages in a given index

3.When in full recovery mode, DBCC DBREINDEX logs images of each index page

Diff between DBReindex and DBCC Showcontig

Wednesday, September 14, 2005

Migrating OLAP Repository database from the Access to SQL Server

Note By default, the OLAP repository database is :\Program Files\Microsoft Analysis Services\Bin\Msmdrep.mdb

More on :

You Receive an Error Message When You Try to Register or Connect to an Analysis Services Computer as a Domain User

Cannot connect to the repository.
Analysis server:

Could not use ''; file already in use.

Thursday, September 08, 2005

SQL Serve Memory Monitoring Parameters

Memory: Available Bytes

Memory: Pages/sec

Process: Working Set ( SQLServer )

SQL Server: Buffer Manager: Buffer Cache Hit Ratio

SQL Server: Buffer Manager: Total Pages

SQL Server: Memory Manager: Total Server Memory (KB)

Monday, September 05, 2005

Comparing SQL Server Databases

PowerDesigner, it’s a modeling tool from Sybase.

1.Just generate the SQL definition for the databases from inside the SQL Server and then import them to the PowerDesigner.
2. Once you have imported both databases in the PowerDesigner you can do many things.

3. You can compare the definitions and the PowerDesigner will generate a complete report with the differences between the two databases. The report will include tables, Keys, Indexes, views … etc