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: 13
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: 13  
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 Exchange Mailbox Usage
by  nhouse24   Go to last post Go to first unread
Last post: Today at 10:31:09 PM(UTC)
Lansweeper Personalize interface user ticket
by  Brighton  
Go to last post Go to first unread
Last post: Today at 9:31:34 PM(UTC)
Lansweeper Update dashboard defaulting to Helpdesk
by  nriddick   Go to last post Go to first unread
Last post: Today at 9:22:18 PM(UTC)
Lansweeper Change Management : Creating new Events type
by  Hugo Lynch  
Go to last post Go to first unread
Last post: Today at 8:05:34 PM(UTC)
Lansweeper Linked Tickets - Helpdesk Workflow/Subordinate Tickets
by  Argon0   Go to last post Go to first unread
Last post: Today at 5:22:27 PM(UTC)
Lansweeper SCCM Scanning Failure
by  wanduster  
Go to last post Go to first unread
Last post: Today at 4:18:47 PM(UTC)
Lansweeper Notification ticket in pending after 1 week
by  Vasile Ciuban   Go to last post Go to first unread
Last post: Today at 3:18:04 PM(UTC)
Lansweeper Assistance on Building a Report on Java Installations
by  Rob-CD  
Go to last post Go to first unread
Last post: Today at 10:20:11 AM(UTC)