Tips ‘N’ Tricks – Windows – Improve the System Startup Performance

Everyone who is using any of the electronic devices like Cell Phones, Tablet PCs, Laptops, and Computers etc. want their system to start really quick requiring as much less time as possible. A system’s startup depends greatly on the Operating Systems and Windows 7 has been exceptional in this aspect and provides a pretty quick system startup. However, the system’s startup depends on various other factors and many of those are under our control like the Windows Services. Managing the Windows Services is one of the ways to improve your computer’s startup performance. Let’s see how it can be done.

I had previously written an article on Starting, Stopping, and Restarting Windows Services from Command Line, wherein I had explained how effectively we can effectively manage Windows Services from Command Line or using a set of Batch Files. In this tip, we will take a step further and look at improving the system’s performance by appropriately making adjustments/settings in these services.

One of the most important settings of a Windows Service is its startup type which greatly affects how fast our system starts up and how efficiently our system performs. There have been following 3 startup options available for Windows Services till Windows XP: Automatic, Manual, and Disabled (last one is more of an enable or disable setting for a service rather than startup service). In Windows 7 (In fact this was introduced in Windows Vista), we have following four startup options: Automatic (Delayed Start), Automatic, Manual, and Disabled.

Windows Service Startup Types in Windows 7

You have the following choices for improving your system’s startup time and also to improve your system’s performance after startup:

  • Set the appropriate Startup Type to improve the system’s startup performance
  • Set the appropriate Startup Type to improve the system’s performance after startup

We will take a look at the first one in this tip. Second option above has been explained in my previous article on Starting, Stopping, and Restarting Windows Services from Command Line.

When the system’s startup type is set to Automatic (Delayed Start), then, first the Windows Operating Systems boots up/starts (including all the essential core components of the OS) and after that the Windows Services which are set to Automatic (Delayed Start) will start in the background while you can start using your computer.

For instance, there are many Windows Services which can start after a few minutes after the system has started like Windows Services for SQL Server. Since you might be interested in starting a few other applications before you can get start with your work on SQL Server like Checking through emails etc. I personally open Microsoft Outlook as the first thing once I log into the computer since it takes a few moments to start downloading the emails while I can continue to start other applications like Internet Explorer etc. in parallel and once emails are downloaded, I can start checking the emails to define the work/action items for the day.

Following screenshot shows Windows Services for SQL Server setup with different startup types based on the need. As you can see, we can keep those services turned off (Disabled) or set them to Manual (so that they don’t start automatically), which are not required for our development/test activities. This will help in effective utilization of available resources on your computer.

Startup types of Windows Services for SQL Server

There is a nice article written by Nakul Vachhrajani (Blog | Twitter) on Improving launch performance of SQL Server Management Studio (SSMS) in 2 simple steps, which shows how we can further improve the launch performance of various applications on Windows to save time and improve productivity. It’s a nice read.

Take a look at the other Tips and Tricks in this Series on Tips, Tricks, Techniques, and Shortcuts to Improve Productivity, and Design and Coding Skills.


About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on June 22, 2012, in Best Practices, Computers, Issues 'N' Resolution, SQL Server, SSAS, SSAS Tips, SSIS, SSIS Tips, SSRS, SSRS Tips, Tips 'N' Tricks, Windows, Windows Tips and tagged , , , , , , , , , , . Bookmark the permalink. Leave a comment.

What are your thoughts?

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: