DB Engine :: Max Value Of Maxtransfersize And Buffercount Adjustment VS Physical Memory On Box

Aug 5, 2015

Eager to know to set the Max Value of Maxtransfersize and Buffercount adjustment but also anxious to know Physical memory impact.URL...The max size that can be used is the (Buffer Pool’s To Physical Memory / 16).  As returned from the GlobalMemoryStatusEx (ullTotalPhys ) API call. HereBob dorr saysBuffer Pool’s To Physical Memory/16 what it means? (ie.  Buffer Pool/ Physical memory/16.0 or (Physical Memory - buffer pool)/16

View 9 Replies


ADVERTISEMENT

DB Engine :: Physical Memory Is High Greater Than 96%

Sep 10, 2015

We have Windows Server 2008R2 installed on VM Server.On that we have three SQL instances running. From few past months we are observing physical memory is going high. Earlier we observed it was at 86-88%, now it is 96-97%.We have 16RAM & 8 CPU cores on VM. what is the best and ideal configuration so that we can rectify the high physical memory issue.

View 13 Replies View Related

Alert For Physical Memory

May 6, 2008

Is there an alert for physical memory in SQL2K5? My requirement is - I should get an alert when the free space on a particular drive comes below a threshhold.

------------------------
I think, therefore I am - Rene Descartes

View 11 Replies View Related

Physical Memory Utilization

Feb 12, 2007

Environment: Win2003 SP1, 32 bit, SQL Server 2K5

My server has 16GB RM but it is using only 3GB. And I see my server is using 3GB of Virtual Memory, too. Why my physical memory is not being utilized? How can I increase Physical Memory usage and decrease VM usage?



Canada DBA

View 19 Replies View Related

Physical Memory 198,250K Available

Aug 30, 2007

We have a sql 2005 server with 8GB of RAM. Task Manager shows that it only has 198,250k (about 200 MB) of Physical Memory available. I wonder if that number should be higher.

What can I check (Perfmon counters? Which ones?) to indicate it that's too little RAM, the right amount, or too much.

Thanks,

Barkingdog

View 1 Replies View Related

Adding More Physical Memory ... Do We Need To Upgrade The OS?

May 24, 2008

We are currently running a server with standard edition Windows Server 2003 R2 with standard edition SQL Server 2005 SP2.

The server has 4GB of memory of which 3GB is dedicated to SQL and 1GB to the OS via the use of the /3GB switch.

If we were to increase the physical memory to 12GB (and carve out 2GB for the OS and 10GB for SQL) would we have to upgrade the OS to Enterprise version to access the additional 8GB of memory we plan to add?

Thanks ALL!

View 1 Replies View Related

DB Engine :: Unable To Open Physical File - Operating System Error 5

Apr 16, 2008

I am trying to attach a database to SQL 2005. This database has not previously been attached. I have only just installed SQL.
 
I get the following message: Unable to open physical file "C:ArrowSQLArr@DataArrow_data.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: Error 5120)".
 
I have loaded SQL and the database fiel and directory with the same user account which is a local administrator on this machine. I have checked that I have read/write access to the file.
 
The machine runs Windows Vista Business. SQL has SP 2 loaded. What causes this?

View 56 Replies View Related

DB Engine :: Memory Grant To CHECKDB

May 16, 2015

How to accurately track how much memory was granted to a DBCC checkdb during it's execution? 

I'd like to do this without continuously querying dm_exec_query_memory_grants, if at all possible - but if that's the only option.

View 7 Replies View Related

DB Engine :: How Server Memory Paging Out

Nov 23, 2015

Is there any easy way to detect SQL Server memory is getting paged out? Any DMV query or tips to confirm it is paging out.

My SQL Server Version is: Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64)

View 5 Replies View Related

DB Engine :: How To Configure TempDB In Memory

Jul 9, 2015

Is it available by default or it has to be Configured. 

If yes then how to configure Tempdb in Memory for SQL 2012 SP2 CU1? 

View 5 Replies View Related

DB Engine :: Min Memory Per Query Server

May 6, 2015

Is there has any SQL query  to check running out of "min memory per query SQL Server"(default value is 1024KB)?

View 2 Replies View Related

SQL 2012 :: Restore Database Command - BufferCount Option?

Jul 22, 2014

What the BUFFERCOUNT option does in a RESTORE DATABASE command?

View 5 Replies View Related

DB Engine :: Set Maximum Server Memory By Using Scripts

Apr 28, 2015

How to set maximum server memory by using sql scripts in sql server 2014?

View 5 Replies View Related

DB Engine :: MAX And MIN Server Memory Settings For 2012?

Sep 8, 2015

We have a new set up on VM to run an application running 24*7 (migrated from SQL server 2008R2) with below configs:

1. OS- Windows server 2012 Standard 64 bit hosted on Virtual Machine

2. Memory 16 GB and Cores =4 with 2.4GhZ processor

3. SQL server 2012 SP2 , 64 bit Standard edition.

4. Total size of databases as of now 15 GB with biggest being 5 GB.

How should i go around in setting the MAX and MIN server memory settings. I have this set up for many of SQL 2005 and 2008R2 servers, but for 2012 i heard that things has slightly changed. 

How should i start analyzing and setting the right value of this MAX and MIN?

View 5 Replies View Related

DB Engine :: Adjust Instance Memory When Service Not Starting

Apr 23, 2015

One server, a part of a 2 node always on cluster, had problems, I had to restart.

I'm getting this error for example now:

Error: 49910, Severity: 10, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
+
SQL Server was unable to run a new system task, either because there is insufficient memory or the number of configured sessions exceeds the maximum allowed in the server. Verify that the server has adequate memory. Use sp_configure with option 'user connections' to check the maximum number of user connections allowed. Use sys.dm_exec_sessions to check the current number of sessions, including user processes.

Now, on the instance I have activated maximum servere memory, my question; Is it possible to adjust this setting without starting the service?

Some parameter for example?

The server itself have enough memory.

View 3 Replies View Related

DB Engine :: Memory Table Not Cleared If Created Inside A While Loop

Oct 29, 2015

If I create a memory table inside a while loop, I expect that every loop the memory table is (newly) created and thus empty.

But when I test this, I see that on the second, third, ... run the inserted data in the memory table is still present and not cleared.

This can be reproduces with the following code:

DECLARE @tbl TABLE
( [id] BIGINT )
DECLARE @tbl2 TABLE
( [value] BIGINT )
INSERT INTO @tbl
VALUES (1), (2)

[Code] ....

/*
Expectation: twice 11 and 12 in @tbl2
Actual result: three times 11 and 12
*/
SELECT *
FROM @tbl2

Is this a wrong assumption or is this a bug in SQL Server? (Tested on: SQL Server 2014 and 2008).

View 2 Replies View Related

DB Engine :: Defining MAX And MIN Server Memory Settings On 2 Node Cluster

Sep 29, 2015

On first Node A: The server has 16 GB of physical RAM. 
On second Node B: The server has 10 GB of physical RAM.

Now, this being Active Active, Node A can be clustered on failure onto Node B..Now reporting server is configured under these two nodes, with defined MAX and MIN server memory of 12 as MAX and 0 is min IN GB.Now with this setting on SQL whenever the cluster moves, such config make OS goes low on node for 10 GB.I am only left with option of switching this MAX and MIN to a default setting or is there any other alternative such as script which can change this setting accordingly when cluster moves to respective server.

View 7 Replies View Related

DB Engine :: Find Total Memory Allocated To Server And CPU Utilization

Apr 30, 2015

I am searching for query to find total memory allocated to sqlserver,  and how much being used utilized as well cpu utilization percentage . 

View 10 Replies View Related

DB Engine :: Reboot / Restart Service After Setting Max Server Memory

Apr 29, 2015

After I have set the maximum sql server memory in sql server 2014 using sp_configure, do I need to reboot whole server or restart sql service?

View 4 Replies View Related

DB Engine :: In-Memory OLTP Use With Existing Tables / Index / Procedures

Nov 10, 2015

1. I need to make use of in memory engine for my pr-existed develop procedures ,tables ,index.  do I need and code changes for application and how to store tables /indexes in OLTP memory

Assume table index may have primary key index as well.

2. If table with one primary index and 2 foreign constraints, 3 non clusters indexed. which one able o load to memory area and how t do that.

3. In memory is lock free zone. usually locks will happpen in RDMS context . how this works without locks.

View 3 Replies View Related

Column Adjustment - From Left To Right

Apr 22, 2015

I need below column amount should be starts from right to left.

Outstanding_balance
-------------------------
98006735.65
98006735.65
12957
1600000
750865

result should be as below
----------

98006735.65
98006735.65
12957
1600000
750865

View 8 Replies View Related

DB Engine :: Insufficient System Memory In Resource Pool Default To Run Query

Jul 7, 2015

My Integrity job started failing recently with the following error. Msg 701, Level 17, State 123, Line 1  There is insufficient system memory in resource pool 'default' to run this query.  Process Exit Code 1.  The step failed.

select @@ version
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4033.0 (X64)
 Jul  9 2014 16:04:25
 Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
System is having 4GB RAM and SQL is using most of it. It has 2 processors.

View 8 Replies View Related

DB Engine :: Disk Block Size For Memory-optimized Tables Filestream Data

May 7, 2015

In SQL Server 2014, how big for the block size is better for performance? 64 KB? 4 KB?

For normal database files, best practise is 64 KB disk block size. Not sure if it is same for memory-optimized filegroup.

View 12 Replies View Related

Time Zone Adjustment In SQL Server 2005 Express

Dec 18, 2005

I am using Visual Web Developer 2005 Express Edition & SQL Server 2005 Express Edition.

In a database that is role-manager-enabled, you will have some tables like apsnet_Users, aspnet_Roles, etc.
And some Columns like CreatedDate, LastLoginDate in the tables.

My problem:
The datatime values in the aforementioned fields are updated based on GMT instead of the client's local time zone.

Is this the way it is?
No matter true or not, how to fix it?

Many Thanks in advance :)

Jey Leong

View 5 Replies View Related

MS SQL Server 2005 Failed To Start After SSL Encryption Adjustment

Mar 21, 2008

Hi, everyone!

I faced the problem trying to adjust ssl encryption in ms sql server 2005.
I've completed all steps from this article:
http://msdn2.microsoft.com/en-us/library/ms191192.aspx

But when I'm trying to restart sql server - it fails to start.

Here the error messages I got:

1. Unable to load user-specified certificate. The server will not accept a connection. You should verify that the certificate is correctly installed. See "Configuring Certificate for Use by SSL" in Books Online.

2. TDSSNIClient initialization failed with error 0x80092004, status code 0x80.

3. TDSSNIClient initialization failed with error 0x80092004, status code 0x1.

4. Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

5. SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.



SQL Server is installed on Windows 2003 Server OS running computer.

I use certificate created by means stand-alone Certificate Authority that appeared in Administration Tools on that computer after I installed Certificate Services.

I guess the reason is in wrong certificate parameters I set while requesting.

How can I determine correct certificate parameters? Does anyone know?


Any help is appreciated,
Thanks

View 4 Replies View Related

SQL In-Memory :: Table Memory Optimization Advisor Validation Passed But Cannot Migrate

Jul 13, 2015

I am looking to test this feature - and the "Transaction Performance Collector" has recommended me a table to port to In-Memory OLTP. 

I have now tried the "Table Memory Optimization Advisor" tool.

After a couple of tweaks to the table design - the tool is now passing validation but the tool is not allowing to progress to the next step:

Could it be down to not having enough memory? But would this not show in the advisor?

View 4 Replies View Related

Attempted To Read Or Write Protected Memory. This Is Often An Indication That Other Memory Is Corrupt. (Microsoft Visual Studio)

Sep 28, 2007

Hello. I have received the follwoing error upon an attempt to Browse the Cube. All other tabs are functional, including the Calculations tab. We are running Windows Server 2003 SP2 and SQL Server 2005 SP2. Any suggestions would be greatly appreciated!

**EDIT** - Have confirmed SP1 for VS2005 is installed both locally and on server, also.


Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (Microsoft Visual Studio)

------------------------------
Program Location:

at Microsoft.Office.Interop.Owc11.PivotView.get_FieldSets()
at Microsoft.AnalysisServices.Controls.PivotTableFontAdjustor.TransformFonts(Font font)
at Microsoft.AnalysisServices.Browse.CubeBrowser.UpdatePivotTable(Boolean translate)
at Microsoft.AnalysisServices.Browse.CubeBrowser.UpdateAll(Boolean translate)
at Microsoft.AnalysisServices.Browse.CubeBrowser.InitialUpdate()
at Microsoft.AnalysisServices.Browse.CubeBrowser.SupportFunctionWhichCanFail(FunctionWhichCanFail function)

View 4 Replies View Related

AWE/Lock Page In Memory Drawbacks? Min/Max Settings, Memory Issues

Oct 11, 2007

I've been researching AWE to determine if we should enable this for our environment.

Currently we have a quad core box with 4 gb of RAM (VMware). OS: Windows 2003 std, SQL Server 2005 std. 3GB is not set but will be as soon as we can perform maintenance on the server.

I have read mixed feedback on AWE, either it works great or grinds you to a hault. I would assume that the grinding to a hault is due to not setting the min/max values correctly or not enabling the lock page in memory setting.

We only have one instance of SQL on the server and this box won't be used for anything else aside from hosting SQL services. We do plan on running SSRS off of this server as well.

1. Will running SSRS and enabling AWE cause me problems? Will I have to reduce the max setting by the SSRS memory usage or will it share and play nice?

2. How do I go about setting the Max value? Should it be less than the physical RAM in the box? Right now its set to the default of 214748364, even if I don't enable AWE should this default value be changed?

3. It seems that even at idle the SQL server holds a lot of memory and the page file grows. If I restart the process in the morning, memory usage in taskmon is at 600mb or so. By the end of the day, its up around 2gb. How can I track down whats causing this, should this even concern me?

4. The lock Page in memory setting worries me. Everything I've read on this seems to give a warning about serious OS and other program support degradation. In some cases to the point where they have to restore the settings on the server before they can bring it back up. What are your thoughts on this.

View 3 Replies View Related

SQL In-Memory :: How To Reduce Memory Usage Without Killing Any Process

Aug 28, 2015

I have a Windows sever 2012 with sql server 2012 enterprise. Ram size is 22GB. Sometimes SQL sever takes 95% memory.My question, How to reduce memory size without killing any process because it's production server.So there are many background process is running. And,Is there any guides to learn why Memory is raise d so high and how to reduce it.

View 10 Replies View Related

Would Max Memory Including SSIS And SSAS Memory

Mar 27, 2008

Hello, I understand that we should use SSMS -> Server Properties -> Memory to put a cap on the SQL server memory usage, therefore it gives some space memory for OS, this is based on the fact if the max memory is not specified, SQL will use whatever available memory and eventually crash the system.

My question is that when a server has SSIS and SSAS services installed along with the SQL service. Would the max memory setting covers the SSIS and SSAS memory usage, or the SSIS and SSAS has to shared the memory with OS?

Thanks,
fshguo.

View 1 Replies View Related

Memory Issues, SSIS Package Out Of Memory Help

Dec 6, 2006

I am running Visual Studio 2005. I have an SSIS Package which is consuming a huge amount of memory. During the execution of the package the memory keeps increasing. Until finally i get an Out of Memory exception. I have run this package using dtexec, and in the BIDS. No difference. I do have some script components and have added some code to get the assemblies in the current appdomain. I do see that one particular assembly is increasing on every loop. VBAssembly every time it hits the script component is increasing by 6, and along with it the memory is climbing. What is this VBAssembly being used for is there an update to SQL Server Integration Services that I need?

Thanks! Aaron B.

View 6 Replies View Related

Sql Server 2000 Using Less Memory After More Memory Added

Aug 22, 2007

sql server 2000 is running on windows server 2003 ... 4gb of memory on server .... 2003 was allocated 2.3gb nd sql server was allocated (and using all of it) 1.6gb for total of approx 4gb based on idera monitor software ... all memory allocated betweeen the OS and sql server .... then 4 more gb of memory added for total now of 8g ... now idera monitor shows 1.7gb for OS and 1.0 gb for sql server ..... 'system' info shows 8gb memory with PAE ... so I assume that the full 8gb can now be addressed .... why are less resources being used now with more total memory .... especially sql server ..... i thought about specifying a minimum memmry for sql server but i amnot convinced that would even work since it seems that this 1gb limit is artificial .... it it used 1.6 gb before why would it not use at least that much now ??

thank you

View 4 Replies View Related

SQL In-Memory :: How To Find Memory Usage By Index

Oct 4, 2015

i want to create a lot of index for my database for performance.but i need find memory usage by indexes.

How to find memory usage by index in sql server?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved