Three Tips on Choosing the Hardware for Your BI Solution

Home > Blogs > SQL Server > Three Tips on Choosing the Hardware for Your BI Solution

Three Tips on Choosing the Hardware for Your BI Solution

Like This Blog 0Don Jones
Added by September 5, 2013

Many small- and medium-sized businesses choose to go with Business Intelligence (BI) solutions that are at least partly pre-built. That means that the biggest single factor in the system’s performance – the database schema – is often already decided and can’t readily be changed. The benefit of that approach is that you’re not paying for a custom data warehouse design, which can be incredibly expensive and time-consuming to create. The downside is that you’re getting no input into the most critical aspect of the system’s performance. What you can do, however, is make sure that the hardware your BI system runs on is up to the challenge.

Dedicate, Please

The worst thing you can do is plan to run your BI system on a server that’s already doing something else. Just forget about it. A truly massive, hyper-powerful, fully-loaded server (without storage) might run you $30,000. If that’s too much, then start compromising, using recommendations from your BI system vendor to determine what corners you can cut (hint: slightly slower processors is preferable to fewer processor sockets and cores). Whatever you do, let the entire computer be dedicated to the BI system.

You see, most BI systems already include multiple components: A database engine, an analysis engine, a Web server, and other stuff. Loading your own applications onto the server is just asking too much from it in terms of performance.

You may also like:  Microsoft White Paper - SQL Server 2016 and Windows Server 2016 Better Together

Some BI systems – and these are ones to look for – may permit you to spread their various sub-components across multiple servers. If BI system performance is a real concern, then look for a BI system that does permit that kind of spreading-out of components. You’ll get more servers on the job, and that equals better performance.

RAM, RAM, RAM, RAM, RAM
Up to a third of the cost of a new server might be Random Access Memory, or RAM – or just memory to most of us. That’s the third where you don’t want to cut corners. The database engine that powers a BI system needs that memory, and it needs it in a bad way. A 25% reduction in installed memory can easily cut system performance in half, depending on the database engine, BI platform, and other components involved. If you can’t afford to fill your new BI server with memory, at least select a server that will have plenty of room for expansion at a later time. Whatever memory you do buy with the server should be the densest possible: If you’re equipping the machine with 32GB of RAM, do so in as few memory modules as possible to allow for maximum expansion later.

Most BI systems targeted at the SMB market these days rely heavily on in-memory analysis engines instead of, or as a major companion to, a more traditional data warehouse database. In-memory analysis means exactly what it says: Analysis is conducted in real-time, on the fly, in the server’s memory. That means your server will need tons and tons of – you guessed it – memory.

You may also like:  Microsoft Second Shot Exams Are On!

Disks – Fast and Plenty

BI systems that rely on a data warehouse (and nearly all of them do to some extent, mostly to a major extent) need their disk performance to be superb. That means more disks, not bigger ones. It’s the inverse of memory: If you want 1TB of disk space, you don’t want it on a single 1TB drive. Ideally, a dozen 100GB drives would be preferable. That’s because disks have physical constraints on their performance, so by spreading your data across more disks, you get better performance.

Choose disks based on rotational speed and average seek time – faster speeds and smaller times are better. Don’t worry about transfer speeds, which is what disk vendors like to tout; with high rotational speed and fast seek times, you generally get great transfer speeds as part of the package.

Don Jones
PowerShell and SQL Instructor – Interface Technical Training
Phoenix, AZ

Videos You May Like

Agile Methodology in Project Management

0 13 0

In this video, you will gain an understanding of Agile and Scrum Master Certification terminologies and concepts to help you make better decisions in your Project Management capabilities. Whether you’re a developer looking to obtain an Agile or Scrum Master Certification, or you’re a Project Manager/Product Owner who is attempting to get your product or … Continue reading Agile Methodology in Project Management

Windows 10 Features and Navigation – December 1, 2015

0 2 1

In this video, Windows Instructor Steve Fullmer presents the navigation and some of the new features associated with Windows 10 including Sysinternals Tools for Windows Client, Windows core concepts, exploring Process Explorer as well as some of the features that are not yet ready for prime time but will be released shortly in the future with Windows 10.

Detailed Forensic Investigation of Malware Infections – April 21, 2015

1 35 1

In this IT Security training video, Security expert Mike Danseglio (CISSP / CEH) will perform several malware investigations including rootkits, botnets, viruses, and browser toolbars.

Write a Comment

Share your thoughts...

Please fill out the comment form below to post a reply.