dbTalk Databases Forums  

tunning

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools tunning

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss tunning in the microsoft.public.sqlserver.tools forum.



Reply
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: tunning - 06-15-2008 , 05:18 PM





Justo (justo (AT) hotmail (DOT) com) writes:
Quote:
I do not have much experience in SQL, which is why I need your help.
What steps should I continue to make a running SQL server and DBS?. You
can defragment the DBS with some software?. I bought the PerfectDisk 8,
but I dare not pass it.
When it comes to defragmenting databases, we usually talk about
defragmenation within the database. A disk fragmenter can be helpful
if the database files themselves are very fragmented, but usually the
problem is with indexes and tables within the database. Defragmenting the
database files is something you maybe only once, but defragmenting indexes
is something you need to regularly to database that is updated frequently.

If you are new to the game, it may be easiest to set up a maintenance
job. And attend a class on SQL Server administration.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #12  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: tunning - 06-15-2008 , 05:18 PM





Justo (justo (AT) hotmail (DOT) com) writes:
Quote:
I do not have much experience in SQL, which is why I need your help.
What steps should I continue to make a running SQL server and DBS?. You
can defragment the DBS with some software?. I bought the PerfectDisk 8,
but I dare not pass it.
When it comes to defragmenting databases, we usually talk about
defragmenation within the database. A disk fragmenter can be helpful
if the database files themselves are very fragmented, but usually the
problem is with indexes and tables within the database. Defragmenting the
database files is something you maybe only once, but defragmenting indexes
is something you need to regularly to database that is updated frequently.

If you are new to the game, it may be easiest to set up a maintenance
job. And attend a class on SQL Server administration.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #13  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: tunning - 06-15-2008 , 05:18 PM


Justo (justo (AT) hotmail (DOT) com) writes:
Quote:
I do not have much experience in SQL, which is why I need your help.
What steps should I continue to make a running SQL server and DBS?. You
can defragment the DBS with some software?. I bought the PerfectDisk 8,
but I dare not pass it.
When it comes to defragmenting databases, we usually talk about
defragmenation within the database. A disk fragmenter can be helpful
if the database files themselves are very fragmented, but usually the
problem is with indexes and tables within the database. Defragmenting the
database files is something you maybe only once, but defragmenting indexes
is something you need to regularly to database that is updated frequently.

If you are new to the game, it may be easiest to set up a maintenance
job. And attend a class on SQL Server administration.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #14  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: tunning - 06-15-2008 , 05:18 PM


Justo (justo (AT) hotmail (DOT) com) writes:
Quote:
I do not have much experience in SQL, which is why I need your help.
What steps should I continue to make a running SQL server and DBS?. You
can defragment the DBS with some software?. I bought the PerfectDisk 8,
but I dare not pass it.
When it comes to defragmenting databases, we usually talk about
defragmenation within the database. A disk fragmenter can be helpful
if the database files themselves are very fragmented, but usually the
problem is with indexes and tables within the database. Defragmenting the
database files is something you maybe only once, but defragmenting indexes
is something you need to regularly to database that is updated frequently.

If you are new to the game, it may be easiest to set up a maintenance
job. And attend a class on SQL Server administration.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #15  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: tunning - 06-15-2008 , 05:18 PM


Justo (justo (AT) hotmail (DOT) com) writes:
Quote:
I do not have much experience in SQL, which is why I need your help.
What steps should I continue to make a running SQL server and DBS?. You
can defragment the DBS with some software?. I bought the PerfectDisk 8,
but I dare not pass it.
When it comes to defragmenting databases, we usually talk about
defragmenation within the database. A disk fragmenter can be helpful
if the database files themselves are very fragmented, but usually the
problem is with indexes and tables within the database. Defragmenting the
database files is something you maybe only once, but defragmenting indexes
is something you need to regularly to database that is updated frequently.

If you are new to the game, it may be easiest to set up a maintenance
job. And attend a class on SQL Server administration.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #16  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: tunning - 06-15-2008 , 05:18 PM


Justo (justo (AT) hotmail (DOT) com) writes:
Quote:
I do not have much experience in SQL, which is why I need your help.
What steps should I continue to make a running SQL server and DBS?. You
can defragment the DBS with some software?. I bought the PerfectDisk 8,
but I dare not pass it.
When it comes to defragmenting databases, we usually talk about
defragmenation within the database. A disk fragmenter can be helpful
if the database files themselves are very fragmented, but usually the
problem is with indexes and tables within the database. Defragmenting the
database files is something you maybe only once, but defragmenting indexes
is something you need to regularly to database that is updated frequently.

If you are new to the game, it may be easiest to set up a maintenance
job. And attend a class on SQL Server administration.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #17  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: tunning - 06-15-2008 , 05:18 PM


Justo (justo (AT) hotmail (DOT) com) writes:
Quote:
I do not have much experience in SQL, which is why I need your help.
What steps should I continue to make a running SQL server and DBS?. You
can defragment the DBS with some software?. I bought the PerfectDisk 8,
but I dare not pass it.
When it comes to defragmenting databases, we usually talk about
defragmenation within the database. A disk fragmenter can be helpful
if the database files themselves are very fragmented, but usually the
problem is with indexes and tables within the database. Defragmenting the
database files is something you maybe only once, but defragmenting indexes
is something you need to regularly to database that is updated frequently.

If you are new to the game, it may be easiest to set up a maintenance
job. And attend a class on SQL Server administration.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #18  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: tunning - 06-15-2008 , 05:18 PM


Justo (justo (AT) hotmail (DOT) com) writes:
Quote:
I do not have much experience in SQL, which is why I need your help.
What steps should I continue to make a running SQL server and DBS?. You
can defragment the DBS with some software?. I bought the PerfectDisk 8,
but I dare not pass it.
When it comes to defragmenting databases, we usually talk about
defragmenation within the database. A disk fragmenter can be helpful
if the database files themselves are very fragmented, but usually the
problem is with indexes and tables within the database. Defragmenting the
database files is something you maybe only once, but defragmenting indexes
is something you need to regularly to database that is updated frequently.

If you are new to the game, it may be easiest to set up a maintenance
job. And attend a class on SQL Server administration.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #19  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: tunning - 06-15-2008 , 05:18 PM


Justo (justo (AT) hotmail (DOT) com) writes:
Quote:
I do not have much experience in SQL, which is why I need your help.
What steps should I continue to make a running SQL server and DBS?. You
can defragment the DBS with some software?. I bought the PerfectDisk 8,
but I dare not pass it.
When it comes to defragmenting databases, we usually talk about
defragmenation within the database. A disk fragmenter can be helpful
if the database files themselves are very fragmented, but usually the
problem is with indexes and tables within the database. Defragmenting the
database files is something you maybe only once, but defragmenting indexes
is something you need to regularly to database that is updated frequently.

If you are new to the game, it may be easiest to set up a maintenance
job. And attend a class on SQL Server administration.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top