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

Articles with tag Storage Management Rss

Search for any content tagged storage management

   Items 1 to 20 of 21    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 | 27,743 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,848 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,690 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,690 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,690 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,690 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,690 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,525 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 | 398 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,135 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,631 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 | 27,743 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,976 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,177 reads

SQL Server local disk storage to SANs

Storage area networks (SANs) improve SQL Server performance. Set up SANs on SQL Server with these best practices on migrating to, and configuring SANs.  Read more...
By Additional Articles 2008/07/07 | Source: SearchSQLServer | Category: hardware
Rating: (not yet rated)  Rate this |   Briefcase | 3,960 reads

SAN basics every SQL Server DBA must know

Learn storage area network (SAN) basics that SQL Server DBAs must know. Understand SQL storage concerning RAID levels, redundancy and snapshots vs. backups.  Read more...
By Additional Articles 2008/06/16 | Source: SearchSQLServer | Category: hardware
Rating:  Rate this |   Briefcase | 4,771 reads

Tips for moving from local disk storage to SANs

Move SQL Server storage to storage area networks (SANs) with network redundancy and storage multipathing tips. Learn about iSCSI databases and SQL failover.  Read more...
By Additional Articles 2008/06/03 | Source: SearchSQLServer | Category: storage management
Rating:  Rate this |   Briefcase | 4,043 reads
   Items 1 to 20 of 21    Older >>