Search: spindles

More Results

Sort by: Relevance | Date

  • SQL Server virtualization: Not always a good idea

    As virtualization has grown more sophisticated, there is more incentive than ever to move SQL Server instances to a virtualized server. The number of physical machines goes down, along with power consumption and licensing costs, and you can... Tip   |   SearchSQLServer.com

  • For your next SQL Server upgrade, rely on replication

    As Microsoft tweaks and polishes the next generation of SQL Server, now called... Tip   |   SearchSQLServer.com

  • Three tips for tweaking SQL Server’s SharePoint performance

    If you’re a “reluctant DBA” supporting Microsoft SQL Server in an environment that uses SharePoint Server, you may find yourself wondering how you can get better... Feature   |   SearchSQLServer.com

  • two-spindle system (twin-spindle system)

    A two-spindle system, also called a twin-spindle system, is a computer design with two internal storage drives. Definition   |   SearchStorage.com

  • SQL Server index tuning for peak performance

    You can’t just create your indexes randomly. They need to contain the right number of the right types of columns. It’s a slippery slope. The wider the index is, the larger it is. The larger the index is, the slower it is. Slower indexes take... Tip   |   SearchSQLServer.com

  • What happened to spindle synchronization?

    I've noticed that very few drives today support spindle synchronization for use in a RAID array as compared to drives from 5-10 years ago. In terms of practicality and feasibility, why is this the case? Do you expect spindle synchronization to make... Ask the Expert   |   SearchStorage.com

  • SQL Server consolidation: Why it's an optimization technique

    For years, SQL Server consolidation has been a widely used strategy. As servers have become more powerful, they can handle more services on a single piece of hardware. With the introduction of multi-core processors a few years ago, servers with... Tip   |   SearchSQLServer.com

  • Tuning SQL Server performance via disk arrays and disk partitioning

    As a DBA, much of your focus is on performance tuning SQL Server. But have you spent time to tune the hardware supporting your SQL Server system? Are you using the optimal disk array configuration? Are the disk partitions aligned? This tip... Tip   |   SearchSQLServer.com

  • Storage area network (SAN) basics every SQL Server DBA must know

    Database administrators take SQL Server storage for granted all too often. The storage area network (SAN) is something a lot of DBAs need to learn more about. By understanding the concept of SANs, we can better manage a SQL Server environment and... Tip   |   SearchSQLServer.com

  • SQL Server backups using SAN database snapshots

    One of the toughest things about managing a big database is the backup window: The bigger a database gets, the longer SQL Server backups take. Ironically, larger databases like data warehouses are also the ones that want the smallest nightly... Tip   |   SearchSQLServer.com

Search Again: