Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Storage Management Rss

   Items 1 to 20 of 24    Older >>
 

Moving Large Table to Different File Group

How to Move Large Table to Different File Group  Read more...
By Raj Gujar 2013/12/06 (first published: 2008/10/16) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 28,111 reads

Running SQLIO with Multiple Files

Not exactly groundbreaking information, but were you aware that you can run SQLIO with multiple files? ¬†Until a couple months...  Read more...
By StrateSQL 2013/02/21 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,377 reads

Move all SQL Server indexed views to a new filegroup

As databases grow, it often becomes necessary to add new I/O paths to accommodate the growing space. Even without growth that requires this scale, it can still be useful to utilize multiple I/O devices to spread out the load. One way that you can make optimal use of new drives is to add a filegroup to the database and move certain objects (say, all of your indexed views) to the new filegroup.  Read more...
By Additional Articles 2013/02/11 | Source: MSSQLTips.com | Category: filegroups
Rating: (not yet rated)  Rate this |   Briefcase | 2,860 reads

Check Used Table Space for User Defined Tables

Query the System Tables to find the space usage, which helps Database Administrators identify the Tables that are using the most space.  Read more...
By Tiger 2012/07/11 | Source: SQLServerCentral.com | Category: storage management
Rating: |  Discuss |   Briefcase | 1,189 reads

SQL Server Central Webinar Series #19: Proactive Data Growth Management

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...
By Press Release 2012/06/12 (first published: 2012/05/29) | Source: SQLServerCentral.com | Category: webinar
Rating:  Rate this |   Briefcase | 4,692 reads

SQL Server Central Webinar Series #19: Proactive Data Growth Management

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...
By Press Release 2012/06/12 (first published: 2012/05/29) | Source: SQLServerCentral.com | Category: webinar
Rating:  Rate this |   Briefcase | 4,692 reads

SQL Server Central Webinar Series #19: Proactive Data Growth Management

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...
By Press Release 2012/06/12 (first published: 2012/05/29) | Source: SQLServerCentral.com | Category: webinar
Rating:  Rate this |   Briefcase | 4,692 reads

SQL Server Central Webinar Series #19: Proactive Data Growth Management

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...
By Press Release 2012/06/12 (first published: 2012/05/29) | Source: SQLServerCentral.com | Category: webinar
Rating:  Rate this |   Briefcase | 4,692 reads

SQL Server Central Webinar Series #19: Proactive Data Growth Management

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...
By Press Release 2012/06/12 (first published: 2012/05/29) | Source: SQLServerCentral.com | Category: webinar
Rating:  Rate this |   Briefcase | 4,692 reads

Mirroring and different sector sizes? BAD IDEA!

Be carefull when replacing a defective (FLASH) storage device, its sector sizes may vary without you knowing it.  Read more...
By Theo Ekelmans 2011/12/27 | Source: SQLServerCentral.com | Category: misaligned log io
Rating: |  Discuss |   Briefcase | 3,580 reads

Disk space alert per drive

This script validates the sufficient disk space per drive. When you'll reach a minimum on a diskdrive, the script will mail all recipients.  Read more...
By Sven Goossens 2011/12/06 | Source: SQLServerCentral.com | Category: storage management
Rating: |  Discuss |   Briefcase | 3,155 reads

How will SSDs change SQL Server storage arrays?

If SSDs are about to make obsolete one of the major driving forces behind the development of SANs (disk latency) then how is the storage array going to change in the near future?  Read more...
By Tony Davis 2010/12/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 402 reads

SQLServerCentral Webinar Series #3: Optimize your SQL Server storage with SQL Storage Compress

Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.  Read more...
By Press Release 2010/10/25 (first published: 2010/10/18) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,909 reads

SQLServerCentral Webinar Series #3: Optimize your SQL Server storage with SQL Storage Compress

Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.  Read more...
By Press Release 2010/10/25 (first published: 2010/10/18) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,909 reads

SQLServerCentral Webinar Series #3: Optimize your SQL Server storage with SQL Storage Compress

Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.  Read more...
By Press Release 2010/10/25 (first published: 2010/10/18) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,909 reads

Reliable Storage Systems for SQL Server

By validating the IO path before commissioning the production database system, and performing ongoing validation through page checksums and DBCC checks, you can hopefully avoid data corruption altogether, or at least nip it in the bud. If corruption occurs, then you have to take the right decisions fast to deal with it. Rod Colledge explains how a pessimistic mindset can be an advantage  Read more...
By Additional Articles 2010/06/03 | Source: SimpleTalk | Category: storage management
Rating:  Rate this |   Briefcase | 2,148 reads

Configuring storage in DB with more writes than reads

Learn how to configure SQL Server database storage with higher disk writes than disk reads. Set up a RAID 10 array, cache configuration and file disk layout.  Read more...
By Additional Articles 2008/12/10 | Source: SearchSQLServer | Category: storage management
Rating:  Rate this |   Briefcase | 2,635 reads

Moving Large Table to Different File Group

How to Move Large Table to Different File Group  Read more...
By Raj Gujar 2013/12/06 (first published: 2008/10/16) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 28,111 reads

Tuning performance via disk arrays and disk

Tuning SQL Server performance means tuning hardware configurations and setup. Learn about configuring disk arrays and SQL disk partitioning alignment.  Read more...
By Additional Articles 2008/09/03 | Source: SearchSQLServer | Category: performance tuning
Rating:  Rate this |   Briefcase | 3,977 reads

Virtual database storage for SQL Server: Friend or foe?

Virtual database storage in SQL Server comes with flexibility of tiered storage and block storage. Get the pros and cons of virtual storage area networks.  Read more...
By Additional Articles 2008/08/05 | Source: SearchSQLServer | Category: storage management
Rating: (not yet rated)  Rate this |   Briefcase | 2,179 reads
   Items 1 to 20 of 24    Older >>
 
Tags
hardware (3)    
performance tuning (3)    
administration (2)    
webinar (2)    
alerts (1)    
blogs (1)    
compression (1)    
database mirroring (1)    
database weekly (1)    
disk (1)    
drive (1)    
editorial (1)    
filegroups (1)    
indexed views (1)    
mail (1)    
misaligned log io (1)    
red gate software (1)    
san (1)    
sector size (1)    
space (1)    
sqlservercentral (1)    
t-sql (1)    
warning (1)