Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

PortalWebHosting
  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

Merak Mail Server
WebSecureStores -- ASP.NET & DotNetNuke Hosting Solutions
FCKeditor Project
Salaro -- Skins and more
OnyakTech
CrystalTech Web Hosting™
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Configure It! (...  can't defragment the mdf file... any suggestions?
Previous Previous
 
Next Next
New Post 6/11/2008 3:06 PM
User is offline Brandon Haynes
703 posts
brandonhaynes.org
7th Ranked


Re: can't defragment the mdf file... any suggestions? 

 CSmith wrote

Physical disk defragmentation is almost never needed. However, defraging Indexes is something that should be done to all databases. Using  DBCC SHOWCONTIG will show if you need to and the amount of fragmentation within the DB. There is a good MS post here that covers fragmentaion on SQL Server 2000 but also applies to 2005.

Also note that SQL Profiler can be a power tool to indentify SQL performance issues. This along with the SQL Tuning Advisor may do the trick for you.

 

This is excellent advice.

Brandon


Brandon Haynes
BrandonHaynes.org
 
New Post 6/11/2008 3:51 PM
User is offline mike wittig
101 posts
9th Ranked


Re: can't defragment the mdf file... any suggestions? 

 CSmith wrote

Physical disk defragmentation is almost never needed.

The server seems a lot slower than when I first set it up with DNN nearly two years ago.  I checked the disk defragmentation and there were red lines throughout the drive even after I defragmented.  It reported that it could not defragment the MDF file, so I assume that the red lines all over the drive represent parts of the MDF file.  I figure if the drive has to hunt all over to get parts of the database, perhaps that is at least partially a cause for the apparent performance drop. 

 

However, defraging Indexes is something that should be done to all databases. Using  DBCC SHOWCONTIG will show if you need to and the amount of fragmentation within the DB. There is a good MS post here that covers fragmentaion on SQL Server 2000 but also applies to 2005.

Also note that SQL Profiler can be a power tool to indentify SQL performance issues. This along with the SQL Tuning Advisor may do the trick for you.

Excellent, I will look into both DBCC SHOWCONTIG and Profiler, and the tuning advisor.  Thanks for the tips!

 
New Post 6/11/2008 4:42 PM
User is offline CSmith
386 posts
www.netdatadesign.com
8th Ranked


Re: can't defragment the mdf file... any suggestions? 

Mike,

 

Unless you database(s) has frequent and large database size changes (which a DNN database does not), the need for disk defragmentation is non existant. Table fragmentation is 99% of all performance issues in SQL DB's. Any table that is modified regularly (Insert, Update, Delete) causes the data in a row to change, not the table, so fragmemtaion occurs. Recreating and creating indexes will increase the fillfactor and thus make the servers job easier by not having to seek excessive pages of data.

There is an article here to get you started. http://www.sql-server-performance.com/articles/dba/dt_dbcc_showcontig_p1.aspx

HTH



 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Configure It! (...  can't defragment the mdf file... any suggestions?
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Personify Design, Inc.
Seattle-based Personify Design has developed customized DotNetNuke websites for a wide range of customers to meet many different types of needs, including distributed authorship across thousands of pages to integrated Verisign e-commerce capabilities.
www.personifydesign.com
DNN Outsourcing
50% more affordable services comparing to Western Europe and US: Custom DotNetNuke module development, skins, consulting, maintainence... Over 15.000 working hours of experience in custom DotNetNuke Solutions development, 8 years experience in outsourcing, excellent references!
www.dnnoutsourcing.com
Expressnet - DotNetNuke Hosting
Expressnet provide premium quality ASP.NET Web Hosting. We specialise in Windows based products including ASP.NET and Microsoft SQL Server. We offer fantastic value packages for DotNetNuke hosting. We also offer free asp.net web hosting
www.expressnet.com.au

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP