question

kev35blues avatar image
kev35blues asked

Storage requirements for SQL Server

Hello, I am in the process of buying a new laptop and I am inexperienced with SQL. I want to make sure I have sufficient capacity to run test databases along the lines of AdventureWorks etc and possibly virtual machines to access practice tutorials etc. If I am getting a solid storage drive will 256GB be sufficient? I will not be using the laptop for gaming, watching netflix. Apart from spreadsheets and databases it will mostly be simple browsing and a bit of I Player. I don't have much experience so any advice would be much appreciated. Many thanks
storage
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Henry avatar image
Henry answered
256 GB SSD should be fine (especially if you use AdventureWork LT –the smaller version). I think you should give more emphasis for the memory. For me a minimum of 8GB RAM is needed to have SQL and other apps in one server. Thanks, Henry
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks henry
0 Likes 0 ·
The more memory the better, especially if VM's come into play. I'd also try to get at least a quad core CPU if at all possible. Dual core will work but depending on what you do you'll see some system slow downs here and there.
0 Likes 0 ·
jason_clark03 avatar image
jason_clark03 answered
As storage size depend upon the use of sql server database like for what purpose you are using. You may go through this link to know more about: https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.