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
ADVERTISEMENT
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
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
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
View Related
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
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
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
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
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
Mar 23, 1999
When I try to connect to my SQL server I get the following error.
Microsoft SQL Enterprise Manager
A connection could not be established to MLM1-[SQL Server] Cant allocate space for object 'Syslogs' in database 'tempdb' because the 'logsegment' segment is full. If you ran space in syslogs dump the transaction log. Otherwise use ALTER DATABASE or sp_extendsegment to increase the size of the segment.
Ok, I am not up on SQL so I'm not sure how to dump my tempdb database. I have a coworker that has only done this sort of thing in the Enterprise Manager and we can't get there. So how do I do this and make sure that I don't blow away any data? Also if I do dump my tempdb will this cure my problems and how do I avoid having this happen again?
Any help would be greatly appreciated,
Jeb
View 1 Replies
View Related
Jan 7, 2006
using vs2005 to build web pages of asp.net 2.0, The database is SQL Server 2000,.But I always fail to connect.
using the following configuration in web.config:
<appSettings> <add key="DSN_student" value="server=(local);uid=admin;pwd=123456;database=network_course"/> </appSettings>
I also failed to connect using the following configuration in web.config:
<add name="network_courseConnectionString1" connectionString="Data Source=(local);Initial Catalog=network_course;User ID=admin;Password=123456;" providerName="System.Data.SqlClient" />
I am a beginner from China and eager to get answers! Thank you!
View 2 Replies
View Related
Jan 18, 2008
I have uploaded my site on localhost and sharing on intranethow can i answer these question? Q1) How many users have loggedin? and using my database?Q2) Which table has lots of load?Q3) how can i immediately close particularly connection?
View 4 Replies
View Related
Dec 8, 2005
Hi !
I need to maintain a record such as how many time any user (e.g, sa) connects to the sql server. Means whenever any person is connecting to the database through application or directly, then i need to know that through which sql user(e.g sa), any body connected.
Regards,
Shabber Abbas Rizvi.
View 1 Replies
View Related
Jul 20, 2005
Is there a utility that will allow me to see what users on my network areconnected/active on SQL server?Ryan
View 4 Replies
View Related
Jul 27, 2006
I am using SQL Server 2005 Express + SP1 on a Windows Small Business Server(SBS) box. The SBS is connected to a client thru LAN.
Following are what I gave as IP address and DNS on the server:
IP: 192.168.16.2, subnet mask : 255.255.255.0, Preferred DNS server: 192.168.16.2, Default gateway and Alternate DNS Server blank
On the client, I have,
IP: 192.168.16.4, subnet mask : 255.255.255.0, Preferred DNS server, Default gateway and Alternate DNS Server blank
I can ping and connect to either of the machines.
If I do a sqlcmd -S "tcp:servernameINSTANCE,port", I get the following error message:
HResult 0x80090304, Level 16, State 1
SQL Network Interfaces: The Local Security Authority cannot be contacted
Sqlcmd: Error: Microsoft SQL Native Client : Cannot generate SSPI context
If I do a sqlcmd -S "tcp:192.168.16.2INSTANCE,port", it connects to SQL Server.
I have the Windows Firewall ON. If I Off the firewall, I do not have any problem at all.
I included File and Printer Sharing, sqlsvr.exe in the Exception list of the Windows Firewall.
Any help to solve the issue is appreciated.
Thanks.
View 7 Replies
View Related
Sep 16, 2015
I have a query that finds all SPID's connected to a particular database:
select d.name, p.*
from sys.databases d join sys.sysprocesses p
on d.database_id = p.dbid
where d.name = 'my_db'
But now we have a new rule that we should not use outdated compatibility views, and one of them is sys.sysprocesses. I checked sys.dm_exec_connections/session/requests but failed to replace my existing code. The first two don't have dbid, the last one, requests, has it, but it selects only currently executing statements.
View 0 Replies
View Related
Sep 5, 2005
I have read that if I change "computer name" and then try to startup sql server it will recognize the changes automatically BUT you need to execute sp_dropserver and sp_addserver procedures too in order to set all thing right.But yesterday I tried it on a Personal edition on xp and after reboot sql server came up without any problem and I could connec it without executing sp_dropserver and sp_addserver! Was it a specific situation or no need to those SPs at all?
View 10 Replies
View Related
Apr 20, 2007
My server is a dual AMD x64 2.19 GHz with 8 GB RAM running under Windows Server 2003 Enterprise Edition with service pack 1 installed. We have SQL 2000 32-bit Enterprise installed in the default instance. AWE is enabled using Dynamically configured SQL Server memory with 6215 MB minimum memory and 6656 maximum memory settings.
I have now installed, side-by-side, SQL Server 2005 Enterprise Edition in a separate named instance. Everything is running fine but I believe SQL Server2005 could run faster and need to ensure I am giving it plenty of resources. I realize AWE is not needed with SQL Server 2005 and I have seen suggestions to grant the SQL Server account the 'lock pages in memory' rights. This box only runs the SQL 2000 and SQL 2005 server databases and I would like to ensure, if possible, that each is splitting the available memory equally, at least until we can retire SQL Server 2000 next year. Any suggestions?
View 8 Replies
View Related
Feb 25, 2015
Recently I needed to find all processes connected to a particular database, let's call it Test_db. I have a simple query to find all connections to my database:
select *
from sys.databases d join sys.sysprocesses p
on d.database_id = p.dbid
where d.name = 'test_db'
But there was a process that was connected to another database like USE another_db_name; but was actually selecting from tables in test_db. Is it possible to catch such connections?
View 7 Replies
View Related
Jul 20, 2005
Hi,i have a problem about the CLIENT-SERVER architecture procedure.Well , i have an application in VB with ADO connection to a table in adatabase on a SQLSERVER 7.0 .Is possible to do that when a client updates a data in a field of my table ,the SERVER communicates to all clients connected to my table that this dataare updated , without the client do anything , for example without aclient-timer to control the data in the server ???thanks
View 2 Replies
View Related
Mar 18, 2008
We have an information retrieval application in which there is a single connection to a database followed by multiple table open, read, and close commands. Response time is consistantly less than 1 second on a LAN.
When Internet connected (not VPN), the first table read is typically fast, but the response time becomes slower and slower after multiple table open, read, and close commands. There seems to be a considerable amount of handshaking based on monitoring of the router's status lights.
View 7 Replies
View Related
Dec 18, 2007
Hi,
Is there a way in SQL Server 2005 to use a select statement to fetch data from a table in another Server while running the query in one Server.
Like using a database Server Link in oracle...
Thanks
Pramod
View 8 Replies
View Related
Jan 5, 2007
I have a website I'm ready to test on the server it will call home. I just got connected to the remote SQL server that it will be using. As I've been creating the site, I've been using the default SQL Express set-up in Visual Studio. Is there a way to have Visual Studio create all those default tables, procedures, etc. OR is there a way to copy all of that stuff from the SQL Express running on my machine to the remote SQL Server 2005?
-Mathminded
View 4 Replies
View Related
Jan 16, 2007
Hello ,
Is possible to specify reationships between tables on SQL Server Compact Edition database in Management Studio Express ?
I can connect to database file , add tables, add data , but I dont't found the right methot to specify reationships as with SQL Server Express.
Any ideas?
View 5 Replies
View Related
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
Oct 16, 2007
Does anyone know if this is a SQL Native Client bug? I've read a previous thread (posted back on Jan. 18th, 2007) about this error, but there are no replies. I am getting this error when I issue the sp_setapprole command using sqlexecdirect() ODBC api call. Is there any way to work around this? Or is there a fix to the SQL Native Client? The error 15002 message text states "The procedure sys.sp_setapprole cannot be executed within a transaction". This is on a new connection so there should be no transactions active at the time. Thanks in advance for any info anyone can provide on this.
View 5 Replies
View Related
Nov 8, 2015
I am receiving the following error when starting a program called ShelbySystems that is supposed to connect to a local database. I don't think this is a security issue but I don't know much about SQL server either so...
DIAG [08001] [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. (17)
DIAG [01000] [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). (2)
System Info:
Windows 10 Home - upgrade from 8 64 bit
SQL server 2012 Express
SQL Backwards compatibility 2005 64 bit
ShelbySystems software v5.4
I am including the trace log in case it is useful.
DBInstall 130c-728ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x00000000
SQLHANDLE * 0x02EC58F4
[code]....
View 2 Replies
View Related
Apr 24, 2014
SQL Server In Memory OLTP 2014?
View 6 Replies
View Related
Oct 9, 2015
I have the following SQL FCI configuration:
NODE1 -256GB
INST1 - 64GB min/64GB max
INST2 - 64GB min/64GB max
NODE2 - 256GB
INST3- 64GB min/64GB max
INST4- 64GB min/64GB max
With this configuration and if all instances are running on the same node there will be enough memory for them to run. Knowing that normally i ll have only 2 instances in each node wouldnt it be better the following config?
NODE1 -256GB
INST1 - 64GB min/128GB max
INST2 - 64GB min/128GB max
NODE2 - 256GB
INST3- 64GB min/128GB max
INST4- 64GB min/128GB max
With this configuration and in case all the instances (due to a failure) start running on only 1 node, SQL will adjust all instances to just use Min memory specified?
View 6 Replies
View Related
Sep 29, 2003
Hi, we have a development server with SQL 2000 SP3 on it. The hardware is dual CPUs server with win2000 Server installed, plus 1Gb of RAM.
With only 60 opened connections, the SQL server is using a 700Mb of RAM, so It became very slow, and I can't find the reason of it. Any ideas? With amount of open tables (objects) it doesn't look normal.
Dim
View 2 Replies
View Related
Feb 4, 2011
I accidentally set max server memory to 0. Now I cannot rectify as there are insufficient resources in internal memory pool to rectify. How I can recover? I've been unsuccessful to date in running sqlcmd in single user mode.
View 9 Replies
View Related
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
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
