Hi All ,
i am using a 3rd s/w(Idera SQL DM to be exact) to perform diagonistics on
my SQL 2000 Server. from the alert log , i got some of the following messages
:
able managed_object (1445580188) in Database Altiris_Incidents (6) has a
reorganization percent of 27%
Table wu_custom_instance (2146106686) in Database Altiris_Incidents (6) has
a reorganization percent of 33%
Table wuci_history (254623950) in Database Altiris_Incidents (6) has a
reorganization percent of 25%
Table tb_Stock (1063674837) in Database SidataSQL_DC (7) has a
reorganization percent of 31%
Table tb_StockInfo (110623437) in Database SidataSQL_DC (7) has a
reorganization percent of 38%
Table tb_Supplier (142623551) in Database SidataSQL_DC (7) has a
reorganization percent of 25%
Table tb_StockCons (1735677231) in Database SidataSQL_DC (7) has a
reorganization percent of 24%
Table tb_Transaction (174623665) in Database SidataSQL_DC (7) has a
reorganization percent of 39%
Table tb_Purchase (292196091) in Database SidataSQL_DC (7) has a
reorganization percent of 48%
what does the organization percent really means ? the same as the fill factor
(i am using the default which is 100%) and what does it mean for my SQL
Server ?
appreciate any advise
tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200512/1Sounds like a question for Idera not SQL Server. Those are their own
custom messages and I assume they mean fragmentation % but who knows. I
think they need to come up with a better alert message than that<g>.
--
Andrew J. Kelly SQL MVP
"maxzsim via SQLMonster.com" <u14644@.uwe> wrote in message
news:593d6713d72ac@.uwe...
> Hi All ,
> i am using a 3rd s/w(Idera SQL DM to be exact) to perform diagonistics
> on
> my SQL 2000 Server. from the alert log , i got some of the following
> messages
> :
> able managed_object (1445580188) in Database Altiris_Incidents (6) has a
> reorganization percent of 27%
> Table wu_custom_instance (2146106686) in Database Altiris_Incidents (6)
> has
> a reorganization percent of 33%
> Table wuci_history (254623950) in Database Altiris_Incidents (6) has a
> reorganization percent of 25%
> Table tb_Stock (1063674837) in Database SidataSQL_DC (7) has a
> reorganization percent of 31%
> Table tb_StockInfo (110623437) in Database SidataSQL_DC (7) has a
> reorganization percent of 38%
> Table tb_Supplier (142623551) in Database SidataSQL_DC (7) has a
> reorganization percent of 25%
> Table tb_StockCons (1735677231) in Database SidataSQL_DC (7) has a
> reorganization percent of 24%
> Table tb_Transaction (174623665) in Database SidataSQL_DC (7) has a
> reorganization percent of 39%
> Table tb_Purchase (292196091) in Database SidataSQL_DC (7) has a
> reorganization percent of 48%
>
> what does the organization percent really means ? the same as the fill
> factor
> (i am using the default which is 100%) and what does it mean for my SQL
> Server ?
> appreciate any advise
> tks & rdgs
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200512/1|||tks Andrew i'l check wif Idera then but on further checks it as per wat you
have mentioned(i.e fragmentation %) as the system is allowing me to whether
to do a defrag or not .
but in SQL Server , which DBCC or other commands can allow me to do a defrag
on the tables
tks & rdgs
Andrew J. Kelly wrote:
>Sounds like a question for Idera not SQL Server. Those are their own
>custom messages and I assume they mean fragmentation % but who knows. I
>think they need to come up with a better alert message than that<g>.
>> Hi All ,
>[quoted text clipped - 39 lines]
>> tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200512/1|||This is a multi-part message in MIME format.
--050700080400090100010001
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
In SQL 2000:
* DBCC SHOWCONTIG will show you the fragmentation stats on indexes.
* DBCC DBREINDEX & DBCC INDEXDEFRAG will rebuild & defragment your
indexes respectively.
In SQL 2005:
* Querying the dynamic management view
sys.dm_db_index_physical_stats will show you the index fragmentation
* use the ALTER INDEX statement to rebuild or defragment your indexes
--
*mike hodgson*
blog: http://sqlnerd.blogspot.com
maxzsim via SQLMonster.com wrote:
>tks Andrew i'l check wif Idera then but on further checks it as per wat you
>have mentioned(i.e fragmentation %) as the system is allowing me to whether
>to do a defrag or not .
>but in SQL Server , which DBCC or other commands can allow me to do a defrag
>on the tables
>tks & rdgs
>Andrew J. Kelly wrote:
>
>>Sounds like a question for Idera not SQL Server. Those are their own
>>custom messages and I assume they mean fragmentation % but who knows. I
>>think they need to come up with a better alert message than that<g>.
>>
>>Hi All ,
>>
>>[quoted text clipped - 39 lines]
>>
>>tks & rdgs
>>
>
>
--050700080400090100010001
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>In SQL 2000:<br>
</tt>
<ul>
<li><tt>DBCC SHOWCONTIG will show you the fragmentation stats on
indexes. <br>
</tt></li>
<li><tt>DBCC DBREINDEX & DBCC INDEXDEFRAG will rebuild &
defragment your indexes respectively.</tt></li>
</ul>
<tt>In SQL 2005:<br>
</tt>
<ul>
<li><tt>Querying the dynamic management view
sys.dm_db_index_physical_stats will show you the index fragmentation</tt></li>
<li><tt>use the ALTER INDEX statement to rebuild or defragment your
indexes<br>
</tt></li>
</ul>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2">blog:</font><font face="Tahoma" size="2"> <a
href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
maxzsim via SQLMonster.com wrote:
<blockquote cite="mid593db7aed34e0@.uwe" type="cite">
<pre wrap="">tks Andrew i'l check wif Idera then but on further checks it as per wat you
have mentioned(i.e fragmentation %) as the system is allowing me to whether
to do a defrag or not .
but in SQL Server , which DBCC or other commands can allow me to do a defrag
on the tables
tks & rdgs
Andrew J. Kelly wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Sounds like a question for Idera not SQL Server. Those are their own
custom messages and I assume they mean fragmentation % but who knows. I
think they need to come up with a better alert message than that<g>.
</pre>
<blockquote type="cite">
<pre wrap="">Hi All ,
</pre>
</blockquote>
<pre wrap="">[quoted text clipped - 39 lines]
</pre>
<blockquote type="cite">
<pre wrap="">tks & rdgs
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!-->
</pre>
</blockquote>
</body>
</html>
--050700080400090100010001--|||tks Mike
Mike Hodgson wrote:
>In SQL 2000:
> * DBCC SHOWCONTIG will show you the fragmentation stats on indexes.
> * DBCC DBREINDEX & DBCC INDEXDEFRAG will rebuild & defragment your
> indexes respectively.
>In SQL 2005:
> * Querying the dynamic management view
> sys.dm_db_index_physical_stats will show you the index fragmentation
> * use the ALTER INDEX statement to rebuild or defragment your indexes
>--
>*mike hodgson*
>blog: http://sqlnerd.blogspot.com
>>tks Andrew i'l check wif Idera then but on further checks it as per wat you
>>have mentioned(i.e fragmentation %) as the system is allowing me to whether
>[quoted text clipped - 24 lines]
>>
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200512/1
No comments:
Post a Comment