New
#1
Help me understand SQL Server
While trying to understand intermittent freezes in my Windows 10 that require hard reboots to recover from I was looking at my event viewer trying to find the culprit. Although I have not yet narrowed down the problem (there are several different errors) I came across several events related to SQL Server "insufficient system memory in resource pool 'internal' to run this query". I'm running a quad core i5 machine with 8 gb of ram. Looking at my list of installed programs I notice that I have the following:
SQL Server 2005 Compact Edition
SQL Server 2008 Setup Support Files
SQL Server 2012 Native Client
SQL Server 2014 Setup
SQL Server 2014
SQL Transact SQL Scriptdom
SQL Server Browser for SQL Server 2014
I've tried to read about exactly what SQL Server is and it's as clear as mud to me. Can someone help me understand what it is? Do I need to have all those versions installed? Thanks in advance for your assistance.