Hello All,
Can I use dbcc dbreindex in a live database or do i need to put it
offline first?
thanx,
joel| Hello All,
|
| Can I use dbcc dbreindex in a live database or do i need to put it
| offline first?
--
Hi Joel,
You can use dbreindex live and you don't need to put the database in
single-user mode. Of course you should run this command during off-peak
hours so your users will not get a performance hit.
Hope this helps,
--
Eric Cárdenas
SQL Server support|||thanks eric,
also i want to know the fillfactor to use in my database which is 3GB in
size and doing a lot of INSERt and UPDATE.
Eric Cardenas wrote:
> | Hello All,
> |
> | Can I use dbcc dbreindex in a live database or do i need to put it
> | offline first?
> --
> Hi Joel,
> You can use dbreindex live and you don't need to put the database in
> single-user mode. Of course you should run this command during off-peak
> hours so your users will not get a performance hit.
> Hope this helps,
> --
> Eric Cárdenas
> SQL Server support
>|||| thanks eric,
| also i want to know the fillfactor to use in my database which is 3GB in
| size and doing a lot of INSERTs and UPDATEs.
--
SQL Server Books Online says:
Note Even for an application oriented for many insert and update
operations, the number of database reads typically outnumber database
writes by a factor of 5 to 10. Therefore, specifying a fill factor other
than the default can degrade database read performance by an amount
inversely proportional to the fill factor setting. For example, a fill
factor value of 50 percent can cause database read performance to degrade
by two times.
It is useful to set the fill factor option to another value only when a new
index is created on a table with existing data, and then only when future
changes in that data can be accurately predicted.
Hope this helps,
--
Eric Cárdenas
SQL Server support
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment