In our office we are using SQL Server 2008R2 Express which is installed in Windows server 2012. The SQL Server database is accessed by more than 60 users in network simultaneously. In recent days we are experiencing slow performance of SQL Server and our programs which makes use of SQL Server.
From last few years we were using Windows Server 2003 with SQL Server 2008 R2 Express. Few months we changed server to Windows Server 2012.
I can analyze the performance of SQL Server using performance counters etc. But before that I wanted to know below details
Is there any limitation in SQL Server 2008 R2 Express like it uses only one core of the CPU? And does it may be a reason for slow performance?
Are there compatibility problems when using old version (SQL Server 2008 R2 Express) on Windows Server 2012?
Is there any need of upgrading to SQL Server 2014 Express? Will I get any good benefits?