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 the processes and …
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 data type: text …
call cobol from MS SQL stored procedure - social.msdn.microsoft.com
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 within the SQL …
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 query, you …
.NET SQL CE Core - Not enough storage is available to complete this ...
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 about " …
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 need to be open in …
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 day. …
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 remote client …