Notification

Icon
Error

Converting to SQL Server - Compact to Server

Posted: Tuesday, October 8, 2019 1:44:42 PM(UTC)
Mikey!

Mikey!

Member Original PosterPosts: 27
0
Like
When converting your installation to SQL Server. What is recommended?

Can you install SQL Server on the same machine, or is it recommended to be separate. And if so, what should the specs be on the SQL server (Memory, HD Space, vCPUs, etc). What version of SQL Server is recommended.

Thanks!

Mike
FixitDave
#1FixitDave Member Posts: 51  
posted: 10/9/2019 5:26:31 PM(UTC)
Originally Posted by: Mikey! Go to Quoted Post
When converting your installation to SQL Server. What is recommended?

Can you install SQL Server on the same machine, or is it recommended to be separate. And if so, what should the specs be on the SQL server (Memory, HD Space, vCPUs, etc). What version of SQL Server is recommended.

Thanks!

Mike


The specs depend on usage, we have separate SQL server (Win2016 & SQL2016).
Our DB size is 11GB and has 10GB RAM assigned with 2 vCPUs.

We noticed a huge improvement migrating SQL to a dedicated SQL server, but depends on number of assets and scanned IPs you have.

Our estate has around 4500 networked assets (PCs, Servers, switches, printers, etc)
Mikey!
#2Mikey! Member Original PosterPosts: 27  
posted: 10/9/2019 5:38:03 PM(UTC)
Yea we only have about 1000 assets, so it should be good. Thanks for the info.

Active Discussions

Lansweeper local admin users of a specific device
by  kdunnett   Go to last post Go to first unread
Last post: 5/25/2020 9:30:26 PM(UTC)
Lansweeper How to get total disk usage of all VM assets
by  Erik.T  
Go to last post Go to first unread
Last post: 5/25/2020 4:49:58 PM(UTC)
Lansweeper Windows Server 2016 & Patch Tuesday May 2020
by  Hendrik.VE   Go to last post Go to first unread
Last post: 5/22/2020 8:20:05 PM(UTC)
Lansweeper Users mapped "shared" printers
by  Andy.S  
Go to last post Go to first unread
Last post: 5/22/2020 4:16:23 PM(UTC)
Lansweeper Report on Assets in a Static Group
by  Andy.S   Go to last post Go to first unread
Last post: 5/22/2020 2:55:03 PM(UTC)
Lansweeper Windows 10 Activation
by  TruSynergy  
Go to last post Go to first unread
Last post: 5/21/2020 7:54:25 PM(UTC)
Lansweeper Filtering Report Based On Active Status
by  CyberCitizen   Go to last post Go to first unread
Last post: 5/21/2020 4:04:33 AM(UTC)
Lansweeper Windows: Unauthorized Administrators (Built-in)
by  Jackie.L  
Go to last post Go to first unread
Last post: 5/20/2020 8:01:17 PM(UTC)