Monday, September 9, 2024

Can you Install SQL Server 2022 on a Surface Pro laptop - Part 1?

 This is where you really start looking installing SQL Server 2022 on a laptop, or a computer. This is in the planning stage of the installation. If you are looking at installation of SQL Servers there are a number of posts for other versions here.


It is possible to install SQL Server 2022 on a laptop as long as it satisfies the hardware and software requirements.

These are the hardware requirements from Microsoft site:

ComponentRequirement
StorageSQL Server requires a minimum of 6 GB of available hard drive space.

Disk space requirements vary with the SQL Server components you install. For more information, see Hard Disk Space Requirements later in this article. For information on supported storage types for data files, see Storage Types for Data Files.
MonitorSQL Server requires Super-VGA (800x600) or higher resolution monitor.
InternetInternet functionality requires Internet access (fees can apply).
Memory 1Minimum:

Express Editions: 512 MB

All other editions: 1 GB

Recommended:

Express Editions: 1 GB

All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
Processor SpeedMinimum: x64 Processor: 1.4 GHz

Recommended: 2.0 GHz or faster
Processor Typex64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support

1 The minimum memory required for installing the Data Quality Server component in Data Quality Services (DQS) is 2 GB of RAM, which is different from the SQL Server minimum


For example I have a Surface Pro older version with the following specs:

Processor 12th Gen Intel(R) Core(TM) i7-1265U   2.70 GHz

Installed RAM 16.0 GB (15.8 GB usable)

System type 64-bit operating system, x64-based processor

Pen and touch Pen and touch support with 10 touch points

Additionally, the Surface Pro has a display capable of a resolution of 2496 x 1664

This makes it easy to decide that SQL Server 2022 can indeed be run on this laptop. However, we need to allocate 6GB for the database which presently, is more than needed.

The laptop also satisfies the software requirements.

Software Requirements:

  • Operating System: Windows 10 version 1607 or greater, or Windows Server 2016 or greater.
  • .NET Framework: Minimum operating systems include the minimum .NET framework required.
  • Network Software: Supported operating systems for SQL Server have built-in network software.

No comments: