No announcements
Found 1940036 threads
-
0 VotesSQL Server memory reservation
Hi, If your SQL server has a total of 10GB of memory and you are running other processes how much memory do the non-SQL processes ...Answered | 2 Replies | 8518 Views | Created by MrMojito - Wednesday, March 14, 2012 6:51 PM | Last reply by MrMojito - Friday, April 27, 2012 12:11 PM
-
0 Votes
SQL memory usage in task manager.
server memory usage is less then 2 lakh records will be retreived successfully.Answered | 3 Replies | 7210 Views | Created by Vinaya Kumar - Monday, May 28, 2012 3:03 PM | Last reply by Vinaya Kumar - Tuesday, May 29, 2012 6:17 PM -
0 Votes
SQL Server Target Memory
I find all the SQL 32bits server, the max memory I can see from task manager is about 1.7 GB....I can't see any of the 32bits SQL ...Answered | 12 Replies | 3107 Views | Created by sakurai_db - Monday, August 12, 2013 4:18 PM | Last reply by sakurai_db - Tuesday, September 3, 2013 7:47 AM -
0 Votes
SQL Server Memory 2012
I think the "target memory" is the max memory that SQL server can be used ??Answered | 8 Replies | 1173 Views | Created by sakurai_db - Tuesday, July 8, 2014 1:48 AM | Last reply by Shanky_621 - Thursday, July 10, 2014 6:57 PM -
1 Votes
Max Memory for Sql Server 2012 ( Standard ) + Analysis on same server
I don't think SSAS is holding back on memory just because SQL Server is using 64GB.Answered | 6 Replies | 6263 Views | Created by valr30 - Wednesday, June 19, 2013 2:50 PM | Last reply by valr30 - Wednesday, June 26, 2013 1:28 PM -
0 Votes
SQL Server memory issue
Hello, Totally agree to what Tom said.Max server memory setting only controls buffer pool there are many direct memory allocation through API ...Answered | 2 Replies | 1242 Views | Created by MvKalyan - Thursday, October 24, 2013 6:29 PM | Last reply by Shanky_621 - Friday, October 25, 2013 5:27 AM -
1 Votes
sql server memory issue
Just to be clear, prior to SQL 2012 the "max server memory" only controls the buffer pool size.Answered | 5 Replies | 1631 Views | Created by fltime - Friday, June 7, 2013 7:11 PM | Last reply by Tom Phillips - Monday, June 10, 2013 1:03 PM -
0 Votes
Memory Management for Server w/ SQL 2005 and SQL 2008
We've got a 2008 R2 server 64 bit that has a single SQL 2005 instance and a single SQL 2008 instance.Answered | 1 Replies | 5552 Views | Created by BrennanBB - Monday, January 24, 2011 9:07 PM | Last reply by Alberto Morillo - Monday, January 24, 2011 9:44 PM -
0 Votes
SQL Server Minimum Server Memory
HI Paul, What Lekss said is absolutely correct Task Manager should never be relied for checking SQL Memory usage.Answered | 2 Replies | 7428 Views | Created by PaulRes - Wednesday, February 9, 2011 7:50 PM | Last reply by Ashwin Menon - Thursday, February 10, 2011 1:15 AM -
0 Votes
SQL server memory limit
Hi But sir I read it in one blog that During the installation of Configuration Manager , the configuration manager checks if the SQL server ...Answered | 4 Replies | 1826 Views | Created by sandeepanand007 - Tuesday, May 2, 2017 12:43 PM | Last reply by sandeepanand007 - Wednesday, May 3, 2017 6:09 AM -
0 Votes
SSAS 2008 R2 - memory usage
are there any other SSAS databases on there or just one database with one 25GB cube?Answered | 6 Replies | 1585 Views | Created by taires - Friday, August 16, 2013 1:19 PM | Last reply by taires - Friday, August 16, 2013 6:50 PM -
0 Votes
SQL Memory
As noted above, if SSAS is running, max memory should be lowered even more.Answered | 7 Replies | 2918 Views | Created by kidstuff - Monday, October 8, 2012 11:25 PM | Last reply by RohitGarg - Tuesday, October 9, 2012 9:47 PM -
0 Votes
Server resource (memory & core)
SQL engine, SSAS, OS, alone.Answered | 8 Replies | 988 Views | Created by KIRUBAKARAN J A - Thursday, December 6, 2018 11:13 AM | Last reply by Uri Dimant - Monday, December 10, 2018 6:53 AM -
1 Votes
SQL SERVER 2012 - MEMORY
Have a look at these articles: Server Memory Server Configuration Options How to: Set a Fixed Amount of ...Answered | 2 Replies | 1664 Views | Created by Patricia_senna - Tuesday, September 3, 2013 6:23 PM | Last reply by Saeid Hasani - Tuesday, September 3, 2013 7:25 PM -
0 Votes
SQL server consumes memory
“Max Server Memory” limits only Bpool, There are allocations in SQL Server outside Bpool which are not controlled by Max server ...Answered | 3 Replies | 3233 Views | Created by ThunderbirdSN - Saturday, December 1, 2012 5:22 PM | Last reply by anuragsh - Monday, December 3, 2012 1:05 PM -
1 Votes
Find what is consuming most of my memory in SSAS database
In this scenario, please refer to below blog: What is using all that memory on my Analysis server instance ?Answered | 6 Replies | 6009 Views | Created by SFatimi - Friday, February 2, 2018 1:52 PM | Last reply by willson yuan - Tuesday, February 6, 2018 7:36 AM -
1 Votes
SQL server memory issue
my problem is fixed i limit Memory usage to SQL server before it was default.Answered | 4 Replies | 2795 Views | Created by Thethi Sukhjinder - Wednesday, March 6, 2013 2:58 AM | Last reply by Thethi Sukhjinder - Thursday, March 28, 2013 2:28 PM -
0 Votes
How to control SSAS query to SQL Server
However, when SSAS processes partitions, it takes my query and wraps another SELECT statement around it.Answered | 1 Replies | 6457 Views | Created by Michael Hotek - Monday, February 22, 2010 4:54 PM | Last reply by Frank Kearney - Monday, February 22, 2010 5:41 PM -
1 Votes
AS Server Running Out of Memory - SQL 2008 R2
The SSAS memory limits only apply to the SSAS process (msmdsrv.exe).Answered | 3 Replies | 3601 Views | Created by Jim Fernandez - Thursday, December 13, 2012 12:22 AM | Last reply by Darren Gosbell - Friday, December 14, 2012 2:38 AM -
2 Votes
SQL Server memory optimization?
How can you tell if your SQL server does not have enough memory?Answered | 2 Replies | 2061 Views | Created by scott_m - Friday, November 22, 2013 2:19 AM | Last reply by Shanky_621 - Friday, November 22, 2013 5:53 AM
No announcements
