Physical Memory: 97% - social.msdn.microsoft.com
Apr 9, 2014 · I have a SQL Server 2008 R2 on Windows Server 2008 R2, on 64-bit virtual machine, dual processors dual quad core , and 32 GB RAM. If I restart the server, and after all …
How to find SQL Queries that consumed more memory
Sep 22, 2017 · The bulk of the RAM used by SQL Server is used for page caching. Queries use very little RAM. What exactly are you trying it find out?
nvarchar 4000 limit - social.msdn.microsoft.com
Oct 7, 2021 · What SQL server are you running? Which version? I know SQL Server 2005 introduced nvarchar (MAX), which allows more data to be stored. Aside from that, I don't think …
call cobol from MS SQL stored procedure
Jul 7, 2015 · Hello - DB2 has built-in support for COBOL so it is relatively easy to execute COBOL program from stored procedures however in SQL Server there is no direct way of doing this.
SQL Job Agent Proxy Fails to Authenticate To Azure File Share
Jun 12, 2020 · The job runs fine locally in Visual Studio The job runs fine when executing from SSISDB catalog from the server console when logged in as the proxy account defined for use …
How do you troubleshoot a slow running query?
Feb 14, 2014 · a. Check blocking b. Any sql or application jobs running c. Are other querys are also slow ,to check where you have to focus query or on sql server d. As we are talking about …
.NET SQL CE Core - Not enough storage is available to complete …
Jul 4, 2011 · As the question is related to the use of SQL Server CE, i am wandering about a move of this thread towards the SQL Server Compact forum , especially after the Jeff remark …
mmsm.exe using lots of memory - social.msdn.microsoft.com
Jul 16, 2010 · I do not see any program in SQL Server 2008 called "mmsm.exe" . There is a "ssms.exe" is the SQL Server Management Studio application. This is a user tool and would …
Memory Pages Per second is too High - social.msdn.microsoft.com
Dec 20, 2016 · We have SQL server hosting 2 instances both instances are used by 2 different applications. We usuaally get this alert"Memory pages per second too high" almost 3+ times a …
Remote Access using Windows Authentication
May 22, 2015 · After 2 days of reading everything on the net about setting up Remote Access of my SQL 2012 Express using Windows Authentication I'm still not able to connect from a …