SQLSRVR.EXE Not Releasing Memory

Sep 3, 2000

Has anyone ever seen a situation where SQLSRVR.EXE starts gobbling RAM when under load but does not seem to release it (as seen by mem usage under Task Manager or the related PerfMon counters?) I am running a test of 4 client applications that are hammering against the server but when I check the stats memory is consumed up to the maximum - when I halt the client applications and reduce the processing load to zero the usage stats still show the SQL engine as holding the memory.

I'm running a copy of SQL 7.0 EE on Win2K Advanced Server, using a Compaq 8500 w/ 750MB RAM.

Any clues?

Thanks,
A

View 1 Replies


ADVERTISEMENT

Using The Database Access Concept In SQLsrvr 2000 To SQLsrvr 2005

Mar 6, 2008

In SQL Server 2000, when i install a client connection only, it also install the enterprise manager, just by adding/register new SQL server. there you can access all the tables.  but in SQL Server 2005 how can I achieve that?  Coz when i only install the client tool for SQL Server 2005 it only enables to connect to database, not accessing it freely and sql server management studio not included.
 
please help..

View 2 Replies View Related

Releasing Memory

May 13, 2008

My application is a VB.net client server app with SQL Express on the backend, for some reason both my SQL server and Application continue to increase their memory usage over time, every procedure utilizes the close method of the sqlconnection and then sets the sqlconnection to nothing. Is there anything else I should be doing to close the connection and prevent this memory increase?

View 2 Replies View Related

Memory Releasing Problem

Feb 6, 2007

vighnahar writes "I am using SQL server 2000 / 2005
If I run any query on SQL server it is using some memory for it’s execution but not releasing it’s memory after completion on SQL query. This is giving a problem in my application. Where for each user it is consuming 400 MB RAM on SQL server. after login of fifteen users server is getting slow.
Is there any way by which I can release memory of SQL server as I don’t want SQL server to keep it’s result etc in memory, So that I can use this memory for other processing.

I am writing sample code of VB6 to check for memory utilization. After clicking on button you can observer memory in task manager.

Private Sub Command1_Click()
Dim con As ADODB.Connection
Dim sSql As String
Dim Rs As New ADODB.Recordset
Set con = New ADODB.Connection
con.Open "Upcrest", "sa", ""
Rs.Open " select * from sientity ", con
MsgBox Rs.Source
Rs.Close
Set Rs = Nothing
con.Close
Set con = Nothing
End Sub"

View 1 Replies View Related

Releasing Memory - Dispose Or Update

Mar 8, 2007

i am using visual web developer 2005 and SQL Express 2005 with VB as the code behindi am using the following code to update the database table         Dim update As New SqlDataSource()        update.ConnectionString = ConfigurationManager.ConnectionStrings("DatabaseConnectionString").ToString()        update.UpdateCommandType = SqlDataSourceCommandType.Text        update.UpdateCommand = "UPDATE orderdetail SET fromdesignstatus = 2 ,progresspercentage = 15 , fromdesignlink = '" +                                                                      designlink + "' WHERE order_id =" + ordersid.ToString()        update.Update()        update.Dispose()        update = Nothing  i am using update.Dispose()  and update = nothing to release the memoryis it really necessary to use both the commandsif not , in my case which one is enough and what is the reasonplease help me 

View 3 Replies View Related

Class That Uses Sql Server Isn't Releasing Memory

May 15, 2006

I'm running into a problem where the class I'm running seems to eat up a lot of memory with sql server.  When it's done running, the memory usage never goes down in taskmanager.  I can't figure out where the memory leak might be.  Here's the code that is being called.  Does anyone see a reason why it would continue to eat memory as it runs and then not release it?  Thanks.
 using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace QueryLoadTester
{
class JobSeeker
{
private string ConStr = @"Data Source=server;Initial Catalog=db;Integrated Security=True";

public JobSeeker() { }

#region UpdateJobSeeker
public void UpdateJobSeeker(string JobSeekerId)
{
string qry = "SELECT top 100 dbo.JobSeeker.JobSeekerID, dbo.JobSeeker.SiteId, dbo.JobSeeker.PositionTitle, dbo.JobSeeker.LocationID, dbo.JobSeeker.CurrentSalary, " +
"dbo.JobSeeker.DesiredSalary, dbo.JobSeeker.MinSalary, dbo.JobSeeker.CurrentHourly, dbo.JobSeeker.MinHourly, dbo.JobSeeker.Comments, " +
"dbo.JobSeeker.Resume, dbo.JobSeeker.WillRelocate, dbo.JobSeeker.DateAdded, dbo.JobSeeker.LastModified FROM dbo.JobSeeker " +
"where dbo.JobSeeker.Active=1 and dbo.JobSeeker.samplejobseeker=0 ";

if (JobSeekerId.Length > 0)
qry += " and dbo.JobSeeker.JobSeekerID=" + JobSeekerId;

qry += " and dbo.JobSeeker.JobSeekerID not in (Select JobSeekerId from JobSeekerFullTextSearch)";

SqlConnection cnInsert = new SqlConnection(ConStr);
SqlDataAdapter adp = new SqlDataAdapter(qry, cnInsert);
cnInsert.Open();
DataSet dsJobSeekers = new DataSet();
adp.Fill(dsJobSeekers);
adp.Dispose(); adp = null;


if (dsJobSeekers.Tables[0].Rows.Count > 0)
{
string jid = string.Empty;
string degree, degreegroup;
StringBuilder sb = new StringBuilder();
SqlCommand cmdInsert = new SqlCommand();
cmdInsert.Connection = cnInsert;

foreach (DataRow dr in dsJobSeekers.Tables[0].Rows)
{
jid = dr["JobSeekerID"].ToString();

if (JobSeekerId.Length > 0)
{
cmdInsert.CommandText = "Delete from JobSeekerFullTextSearch where JobSeekerId=" + JobSeekerId;
cmdInsert.ExecuteNonQuery();
}

DataSet dsExtras = GetJobSeekerExtras(jid, cnInsert);

SqlTransaction trans = cnInsert.BeginTransaction();
cmdInsert.Transaction = trans;

degree = degreegroup = string.Empty;

#region insert record into fulltextsearch
try
{
sb.Remove(0, sb.Length);
sb.Append("Insert into JobSeekerFullTextSearch (JobSeekerId, PositionTitle, LocationID, CurrentSalary, ");
sb.Append("DesiredSalary, MinSalary, CurrentHourly, MinHourly, CommentsResume, SiteId, WillRelocate, DateAdded, LastModified) values (");
sb.Append(jid);
sb.Append(",'");
sb.Append(dr["PositionTitle"].ToString().Replace("'", "''"));
sb.Append("',");
sb.Append("'");
sb.Append(dr["LocationID"].ToString().Replace("'", "''"));
sb.Append("',");
sb.Append(Nullify(dr["CurrentSalary"]));
sb.Append(",");
sb.Append(Nullify(dr["DesiredSalary"]));
sb.Append(",");
sb.Append(Nullify(dr["MinSalary"]));
sb.Append(",");
sb.Append(Nullify(dr["CurrentHourly"]));
sb.Append(",");
sb.Append(Nullify(dr["MinHourly"]));
sb.Append(",'");
sb.Append(dr["Comments"].ToString().Replace("'", "''"));
sb.Append(" ");
sb.Append(dr["Resume"].ToString().Replace("'", "''"));
sb.Append("',");
sb.Append(dr["SiteId"].ToString());
sb.Append(",");
sb.Append(Convert.ToInt32(Convert.ToBoolean(dr["WillRelocate"].ToString())));
sb.Append(",'");
sb.Append(dr["DateAdded"].ToString());
sb.Append("','");
sb.Append(dr["LastModified"].ToString());
sb.Append("')");

cmdInsert.CommandText = sb.ToString();

cmdInsert.ExecuteNonQuery();

#region dsExtras insert
//degree info
if (dsExtras.Tables.Count > 0 && dsExtras.Tables[0].Rows.Count > 0)
{
degree = dsExtras.Tables[0].Rows[0][0].ToString();
degreegroup = dsExtras.Tables[0].Rows[0][1].ToString();

if (degree.Length > 0 || degreegroup.Length > 0)
{
sb.Remove(0, sb.Length);
sb.Append("Update JobSeekerFullTextSearch set DegreeLevel='");
sb.Append(degree);
sb.Append("', DegreeLevelGroup=");
sb.Append(degreegroup);
sb.Append(" where JobSeekerId=");
sb.Append(jid);
cmdInsert.CommandText = sb.ToString();
cmdInsert.ExecuteNonQuery();
}
}

//disciplines info
if (dsExtras.Tables.Count > 1 && dsExtras.Tables[1].Rows.Count > 0)
{
sb.Remove(0, sb.Length);

foreach (DataRow d in dsExtras.Tables[1].Rows)
{
sb.Append(d[0].ToString());
sb.Append(",");
}
if (sb.ToString().Length > 0)
{
cmdInsert.CommandText = "Update JobSeekerFullTextSearch set DisciplineIdList='" + sb.ToString().Substring(0, sb.ToString().Length - 1) + "' where JobSeekerId=" + jid;
cmdInsert.ExecuteNonQuery();
}
}

//industries info
if (dsExtras.Tables.Count > 2 && dsExtras.Tables[2].Rows.Count > 0)
{
sb.Remove(0, sb.Length);

foreach (DataRow d in dsExtras.Tables[2].Rows)
{
sb.Append(d[0].ToString());
sb.Append(",");
}
if (sb.ToString().Length > 0)
{
cmdInsert.CommandText = "Update JobSeekerFullTextSearch set IndustryIdList='" + sb.ToString().Substring(0, sb.ToString().Length - 1) + "' where JobSeekerId=" + jid;
cmdInsert.ExecuteNonQuery();
}
}


//jobtypes info
if (dsExtras.Tables.Count > 3 && dsExtras.Tables[3].Rows.Count > 0)
{
sb.Remove(0, sb.Length);

foreach (DataRow d in dsExtras.Tables[3].Rows)
{
sb.Append(d[0].ToString());
sb.Append(",");
}
if (sb.ToString().Length > 0)
{
cmdInsert.CommandText = "Update JobSeekerFullTextSearch set JobTypeIdList='" + sb.ToString().Substring(0, sb.ToString().Length - 1) + "' where JobSeekerId=" + jid;
cmdInsert.ExecuteNonQuery();
}
}
#endregion

trans.Commit();
Console.WriteLine("Insert for " + jid);
}
catch (Exception exc)
{
trans.Rollback();
Console.WriteLine(jid + " - " + exc.ToString());
}
finally
{
trans.Dispose(); trans = null;
}
#endregion

dsExtras.Clear(); dsExtras.Dispose(); dsExtras = null;

}//end foreach
cmdInsert.Dispose(); cmdInsert = null;
}
cnInsert.Close(); cnInsert.Dispose(); cnInsert = null;
GC.Collect();
}
#endregion

#region GetJobSeekerExtras
private static DataSet GetJobSeekerExtras(string JobSeekerId, SqlConnection cn)
{
string qry = "Select JobSeekerDegree.DegreeLevel, VDegreeLevels.DegreeGroup from JobSeekerDegree inner join " +
" VDegreeLevels on JobSeekerDegree.DegreeLevel=VDegreeLevels.DegreeLevel where JobSeekerId=" + JobSeekerId + ";" +
"Select DisciplineID from JobSeekerDiscipline where JobSeekerId=" + JobSeekerId + ";" +
"Select IndustryID from JobSeekerIndustry where JobSeekerID=" + JobSeekerId + ";" +
"Select JobTypeID from JobSeekerJobType where JobSeekerID=" + JobSeekerId;

DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(qry, cn);
adp.Fill(ds);
adp.Dispose(); adp = null;
return ds;

}
#endregion

#region Nullify
private static string Nullify(object p)
{
if (p != System.DBNull.Value)
return p.ToString();
else
return "null";
}
#endregion
}
}

View 5 Replies View Related

SQL Server Memory Not Releasing When Not Connected To Server

Jun 2, 2004

Hello all,

When I close a web form that has a connection to my SQL Server, I am not seeing the memory process close in task manager (of the SQL Server). I am using the "open late close early" theory of database connections. I am using the "close" method for my database connections. Is there any automated utility that will shut down these processes? I thought when the user was disconnected from the database, the memory process would automatically shut down.

Any suggestions, thoughts, or ideas?

TYIA,
lonelobo

View 1 Replies View Related

Unable To Login SQLSrvr 7.0 With 'sa' User

Jan 28, 2004

Hi

I am running into a problem loggin into SQLsrver 7.0 using 'sa' account but works fine admin account(NT acct)

I have installed sqlsrvr 7.0 on win2k - server standard edition. Installed SQLserver using NT domain account. I have created a username 'sa' with admin previleges. When I try to login with sa, login fails in the enterprise manager. ?

I tried to re-install the server7.0 using local account, again unable to login with 'sa' account in the enterprise manager

Appreciate if you could shed some lights on this issue

View 1 Replies View Related

SQLserver (sqlsrvr.exe) Process Is Being Paged Out!

Jun 15, 2007

We are running SQL 2005 SP2 x64 on Windows 2003 SP2 X64.

Server specs:
Quad Core, each core runs at 2.33Ghz.
4GB memory
OS and SQL on RAID 1 set
Transaction log on RAID 1 set
Databases on RAID 5 set

-The SQL service account is a domain account with the "lock pages in memory" rights.
-The min memory use for sql server is 3000MBand the maximum is 2147483647MB.


For whatever reason, the sqlsrvr.exe process uses much less physical memory than the Virtual Memory (VM). When I look at the Task manager, I see 230MB for Mem Usage column and 300MB for VM size column under full workload. Why is the SQL server process being paged out? I have 3GB for it to use. Should I be concerned about the my SQL server?

I didn't configure the AWE as MS doesn't recomment using it on x64 bit systems. When I do "dbcc memorystatus", I get the following:

VM Reserved 4269536
VM Committed 196680
AWE Allocated 0
Reserved Memory 1024
Reserved Memory In Use 0

I thought granting "lock pages in memory" rights to the sql service account automatically enables AWE in x64 bit version of SQL 2005 standard server.

Thanks

View 5 Replies View Related

SQL Server Is Not Releasing Extended SP DLL

Nov 3, 2006

During a Wise Installation upgrade of our software, we are renaming a
directory that contains our ExtendedSP DLL. We issue a
DBCC TSWSQLXP(Free) call before doing the rename, yet SQL Server,
still "holds on" to that DLL. We install a new version, and the ListDLLs
utility (from sysinternals) lists the new DLL in the correct directory.

However, when trying to remove the renamed directory, it won't let us
remove the old DLL because it says it is in use. We can delete the NEW
DLL in the NEW directory with no problem.

I have run the DBCC call numerous times and SQL Server STILL won't
release the DLL for deletion. The only way to delete the OLD DLL is to
stop the SQL Server, delete the DLL, and then restart SQL Server. We
do NOT want to do this because there may be other processes running in
SQL Server.

Any help here would be greatly appreciated.

View 4 Replies View Related

Releasing Space Using Commands

Feb 21, 2008

Hi,

I have 250 mb allocated on my db.

I have two main tables which are taking up the most space

name rows reserved data index_size unused

aspnet_Users 79225 48280 KB 23080 KB 25080 KB 120 KB

aspnet_Profile 69228 132680 KB 131456 KB 568 KB 656 KB


When i deleted some 8000 rows from aspnet_profile, some space should have been released. On the contrary, the db size increased. Where did the space go and why did the db size increase after deleting the records? There are no triggers either.

I thought it might be log files..but my hosting provider tells me that db is set to Simple Recovery which does not utilize a Log File. So we cannot shrink it.

Any idea how can i release some space. Does truncating a table release db space and not fill the log?

Please guide step by step. I am not very thorough with sql

thankls

View 2 Replies View Related

Log File Shrink Not Releasing The Space On Disk

Oct 4, 2007

Hi all

My Transactional log size increased to 39GB, it is in full recovery mode,

To regain the space, i have done the following
BACKUP LOG DB_NAME WITH TRUNCATE_ONLY
DBCC SHRINK_FILE (LOG_FILE_NAME,500)
But not able to regain the space in the hard disk.

No Transactional backups to truncate the log file were setup.

Can you please tell me why the space was released and what should i do further to clean up the sapce

View 4 Replies View Related

Sql Server 2005 Queries Start Timing Out Because Sa Is Acquriing And Releasing Locks

Oct 23, 2007

I have a co-worker whose sql server 2005 is exhibiting strange behavior. We have already re-installed sql server 2005 and service packed it to SP2 to try and see if the behavior stops but it has not.

Every so often during the day sql server 2005 will start to slow down to the point that my co-worker's queries begin to time out. He turned on profiler to look at what was going on behind the scenes.

We see where sa is releasing and acquring locks to the tune of 180,000 rows in a fifteen minute span when this behavior starts so does his time outs. He has reporting options and analysis services installed but not configured. His only connection is to his local database. Occasionally, you see a number like - (03000d8f0ecc) appear in the Text Data column in profiler for sa. I read something about reporting options using sa for clean up but I don't think that is what is happening here.

Does someone have a clue as to what is happening and a way we can prevent the behavior? It is affecting his ability to work on his application.

Thx

View 1 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

SQL In-Memory :: Remove Memory Optimized Filegroup

Jun 15, 2015

I've a database with a memory optimized filegroup on it. How can I remove it?I have removed the memory optimized table I had on it, but when I try to remove the filegroup I receive an error.

View 12 Replies View Related

Update - Not Releasing The Lock After Update

Sep 16, 1999

Pls. help me,

How can I kill the LOCK after update is completed in the table?

My application is complaining that other user still using the system.


This is a part of my trigger to do un update on CallLog table

.......
begin transaction
Update Heat.CallLog
set ModTime=@Vancovertime Where CallID=@strCallID
Commit Transaction

View 1 Replies View Related

Memory Management (fixed Memory, AWE)

Jul 17, 2006

Hi,

I am going to install SQL Server 2000 (then SQL 2K5) on a Win Server 2K3 with 8 GB of ram, but it will be 16 GB in the near future.

I would like to reserve a fixed memory (for momemt less than 3-4 GB) for SQL Server and the rest for application (virtualization).

Without AWE enabled, max memory for SQL Server 2K5 is 4GB as for SQL Server 2000?

How can I manage and optimize memory keeping in mind AWE. (any doc, website available?)

Thank







View 5 Replies View Related

SQL 2012 :: Configuring Memory Per Query Option And Index Create Memory Option

Feb 10, 2015

So I started a new job recently and have noticed a few strange configurations. Typically I would never mess with min memory per query option and index create memory option configuration because i just haven't seen any need to. My typical thought is that if it isn't broke... They have been modified on every single server in my environment.

From Books Online:
• This option is an advanced option and should be changed only by an experienced database administrator or certified SQL Server technician.
• The index create memory option is self-configuring and usually works without requiring adjustment. However, if you experience difficulties creating indexes, consider increasing the value of this option from its run value.

View 3 Replies View Related

How Do You Troubleshoot Memory Leak Issues? What Tools Can Use To Diagnose Memory Leak Problems? In MS SQL ?

Mar 20, 2008

Hello frnds Can Anybody explai what does it mean by question itself and how to resole it ?

View 2 Replies View Related

Performance Issues Total Server Memory Vs Target Server Memory

Aug 2, 2006

Hi

I did a load testing and found the following observations:

1. The Memory:Pages/sec was crossing the limit beyond 20.

2. The Target Server Memory was always greater than Total Server Memory

Seeing the above data it seems to be memory pressure. But I found that AvailableMemory was always above 200 MB. Also Buffer Cache HitRatio was close to 99.99. What could be the reason for the above behavior?

View 1 Replies View Related

Questions About Memory Based Bulk Copy Operation(InsertRow Count,array Insert Directly,set Memory Based Bulk Copy Option)

Feb 15, 2007

Hi~, I have 3 questions about memory based bulk copy.

1. What is the limitation count of IRowsetFastLoad::InsertRow() method before IRowsetFastLoad::Commit(true)?
For example, how much insert row at below sample?(the max value of nCount)
for(i=0 ; i<nCount ; i++)
{
pIFastLoad->InsertRow(hAccessor, (void*)(&BulkData));
}

2. In above code sample, isn't there method of inserting prepared array at once directly(BulkData array, not for loop)

3. In OLE DB memory based bulk copy, what is the equivalent of below's T-SQL bulk copy option ?
BULK INSERT database_name.schema_name.table_name FROM 'data_file' WITH (ROWS_PER_BATCH = rows_per_batch, TABLOCK);

-------------------------------------------------------
My solution is like this. Is it correct?

// CoCreateInstance(...);
// Data source
// Create session

m_TableID.uName.pwszName = m_wszTableName;
m_TableID.eKind = DBKIND_NAME;

DBPROP rgProps[1];
DBPROPSET PropSet[1];

rgProps[0].dwOptions = DBPROPOPTIONS_REQUIRED;
rgProps[0].colid = DB_NULLID;
rgProps[0].vValue.vt = VT_BSTR;
rgProps[0].dwPropertyID = SSPROP_FASTLOADOPTIONS;
rgProps[0].vValue.bstrVal = L"ROWS_PER_BATCH = 10000,TABLOCK";

PropSet[0].rgProperties = rgProps;
PropSet[0].cProperties = 1;
PropSet[0].guidPropertySet = DBPROPSET_SQLSERVERROWSET;

if(m_pIOpenRowset)
{
if(FAILED(m_pIOpenRowset->OpenRowset(NULL,&m_TableID,NULL,IID_IRowsetFastLoad,1,PropSet,(LPUNKNOWN*)&m_pIRowsetFastLoad)))
{
return FALSE;
}
}
else
{
return FALSE;
}

View 6 Replies View Related

Is SQL 2005 Memory Limitation &&<= OS Memory Limitation?

Nov 13, 2006

If I install SQL 2005 Standard on Windows 2003 Standard, is SQL limited to 4 gigs of physical RAM?

I'm planning a new system that will run SQL 2005 Standard edition on a Windows 2003 Standard platform. The spec calls for 8 GB of RAM. My experience would lead me to suspect I need to install Windows 2003 Enterprise to take advantage of all the installed memory.

View 3 Replies View Related

Got Enough Memory???

Feb 9, 2005

We have a box with dual Intel Xeon 3.4GHz processors, and 8GB RAM, OS and Data on separate RAID5 arrays. It runs:
MS Win2k3 Enterprise for the OS,
MS SQLServer 2k Enterprise for DB,
MS SQL Analysis Services for OLAP,
MS SQL Reporting Services for reports distrib,
MS IIS for web hosting,
SPSS OLAPHub for OLAP web UI, and other small stuff...

My question is this: How should the memory be configured? Should we use the OS' /3GB switch or are there enough apps running here for the OS to need 2GB to track them? What SQLServer switches would you run? I'm not sure that I want to lock more that 3-4GB of SQL data pages into memory and starve the other pigs... How could I set this up to keep 2GB for the OS and yet really use the remaining 6GB most effectively?

All input is sincerely appreciated.
Robert

View 7 Replies View Related

Memory

Mar 26, 2001

I had the drives switched out on my sever this weekend and the memory is
running at a consistent 100%.

OS: NT Server 4.0 SP6
SQL Server 7.0 SP1
Drives:
From: 60gb To: 210gb
Memory: 1gb (will be increasing to 2gb)
Pagefile: 3gb

Can anyone tell me why or what would be causing all the memory to be
used?

View 1 Replies View Related

Is SQL A Memory Hog?

Aug 3, 2000

I have been tracking SQL's memory usage over the past few months with Perfmon. I have noticed a trend that little by little "% Committed Bytes in Use" creeps up starting at 8% and eventually climing as high at 35%. I stop and start the SQL services and the total comes back down to 8%. This happens over a week and a half or two week period. Is this normal SQL activity?

Thanks for your help!

DOUG

View 1 Replies View Related

How Much Memory To Buy....

Dec 14, 2000

I am going to purchase a new server to run Eastman's OpenImage software's CATALOG database. Our current server is SQL 6.5,
but it is not able to be upgraded to SQL 7.0 (known bug with this particular HP server). So I am going to buy a new one. My question is
where to find documentation that could recommend how much memory to purchase for this server. I can find scads of documents
detailing how much RAM to give SQL given a fixed amount of RAM on your server, but nowwhere can I find how much RAM to get when
buying a new server.

Any tips?

Thanks,

Joe

View 1 Replies View Related







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