Forum Discussion
Standalone Gateway plus SQL Server and/or SSAS without domain
Yes, I have done that, and have found that due to the things I mentioned it is a not so good idea. If you must, get a PC with at least 8 cores, reserve some of the cores to SQL server, get at least 16 (better 32) GB of RAM and limit SQL Server to a maximum of 8 GB. Have 50 GB of free space on drive C at all times - move your swap file and SQL log files to a different drive letter.
Yes, I have done that, and have found that due to the things I mentioned it is a not so good idea. If you must, get a PC with at least 8 cores, reserve some of the cores to SQL server, get at least 16 (better 32) GB of RAM and limit SQL Server to a maximum of 8 GB. Have 50 GB of free space on drive C at all times - move your swap file and SQL log files to a different drive letter.
Thanks lbendlin. That sounds good. My developer PC should be able to handle it for demo purposes. The services don't need to be running the entire time only when I need to showcase them. It is good to know that I can set that up without being part of a domain.