We are dealing with occasional problems running out of virtual address space. I have implemented a job that records VAS every two minutes using the dm_os_virtual_address_dump function. When I notice a big drop in VAS I look at the SQL log and see event like:
Common language runtime (CLR) functionality initialized using CLR version v2.0.50727 from C:WINDOWSMicrosoft.NETFrameworkv2.0.50727
AppDomain 2 (32767.dbo[runtime].1) created.
In this case VAS dropped from 53MB down to 7MB. Then just 5 minute later I see these events
AppDomain 2 (32767.dbo[runtime].1) is marked for unload due to memory pressure
AppDomain 2 (32767.dbo[runtime].1) unloaded.
But we don't seem to recover any VAS and eventually have to reboot. We are using replication and I sometimes see this when replication restarts after we have an out of sync data issue. We do not have SQL CLR enabled.
Does anyone have any insight on what is going on? What triggers these AppDomains to be created and why does it eat up all the VAS? How could replication have anything to do with it?
We are running... SQL Server 2005 Enterprise sp2 (with hotfix 3175)
Windows Server Enterprise 2003 SP1 32GB RAM Max Server Memory in sp_configure = 29000MB
After deleting all the test data from all tables in a SQL 2000 database, is there a way to reset all the auto-incrementing fields back to zero in one shot? In Access, you can run the Compact and Repair option. Also, in Sybase SQL, there was an "unload/reload" option to reduce the database size. Is there a similar function in SQL2000? Thanks for all the help
I canceled a restore job, and now the database is marked (Loading). When I go to propertied it tells me "database can't be opened, it's in a middle of a restore" Yet from a Query window I can connect and run queries against that database. Should I just wait until it finishes "Loading" or should I re-start the server? Thanks
After the power failure my database was marked suspect. According to my associate we will execute SQL command sp_resetstatus. My question is what are the things we have to do first before we execute the command? We are using NT 4.
I have a 3GB DB that I was running an update script on. The sript failed and ran out of transaction log space. I expanded it and stopped and restarted SQL. The user DB is now marked as recovering. How long should I wait for it to recover? I don't want to have to restore again and start all over with my script. Please help.
Usman Masood writes "we were using our database named db1. when suddenly it stopped working and upon checking it gave an error that db1 and db2 are marked as suspected. while we were only using db1,,,,what is the cause of this error?"
DBCC CHECKDB (A2PD,REPAIR_ALLOW_DATA_LOSS) The above command was not executed as there was some long rollback was going from a user...
I stopped and re started the MSSQLSERVR service...
Then i found the follwing error..
how can i work with the database A2PD marked as suspect
Server: Msg 926, Level 14, State 1, Line 1 Database 'A2PD' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
Hi,I restored my Windows XP system and discovered that I cannot access aMSDE DB that was saved in D: drive (I restored my primary partition inC). How can I restore it?Thanks a lot.
It's no secret that the number of pages in a rendered report varies depending on the format. I have no problem getting the total number of pages for reports rendered in image formats from the web service, but I can't figure out how to get the number of pages for reports rendered in HTML.
I've always been under the impression that the Report Manager that ships with SSRS uses the same web service (reportservice.asmx) and IT can get the number of HTML pages, so it has to be possible.
Hi there, I need urgent help regarding a database that has been marked as suspect. I need to get the data from the database!!
I have a copy of the structure of the database but I need to get cerain very recent data from the database. I have tried bcp and it doesn't work. The backup that I have won't sufice
If a database is marked as suspect, Will it recover?> And if so how long will it take. If it won't recover is there any other way of getting the data, Thanks in advance, Fin
i have a scheduled job which shrinks the database every day once at 12 am
today the job got failed
In the view Job history its showing the below contents ------------------------------------------------------- Database 'ecatalog' is already open and can only have one user at a time. [SQLSTATE 42000] (Error 924) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528). The step failed.
And in Application Log of event viewer its showing the below contents ------------------------------------------------------------------------------ The description for Event ID ( 208 ) in Source ( SQLServerAgent$ABCSQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: Shrink Database - ecatalog, 0xA0C4F8157A744244A61A4ECABE8C6056, Failed, 4/19/2004 12:00:03 AM, The job failed. The Job was invoked by Schedule 27 (Shrink Database - ecatalog). The last step to run was step 1 (Shrink Database - ecatalog)..
I ran the job manually it worked fine
but now when i go and see the database ecatalog in my Enterprise Manager it is showing ecatalog(Single User) What is the meaning of this, will this make any problem to my database
After I restore a database with SQL the database I cannot access it. However, after restoring using Enterprise Manager I do not have the same problem. The message I get is:
Database 'les_test' cannot be opened. It is in the middle of a restore.
The code I am trying to use for the restore is:
RESTORE DATABASE les_test FROM DISK = 'c:MSSQL7BACKUPiztrobeta_db_200012011201.BAK' WITH NORECOVERY, REPLACE, MOVE 'biztrobeta_PRI' TO 'c:mssql7DATAiztrobeta_PRI.ndf', MOVE 'biztrobeta_FGE_Dat1' TO 'c:mssql7DATAiztrobeta_FGE_Dat1.ndf', MOVE 'biztrobeta_FGX_Idx1 ' TO 'c:mssql7DATAiztrobeta_FGX_Idx1.ndf', MOVE 'biztrobeta_LOG' TO 'c:mssql7Dataiztrobeta_LOG.ldf' GO
I tried changing the status in the master..sysdatabases tables, but the restored database was still not accessible. I tried to do this using the following statment:
UPDATE sysdatabases SET STATUS = 4194316 WHERE name = 'les_test' GO
I have the MS SQL2000 database failed to recover at computer restart. Now the database is marked suspect. How can I manage to recover the data? Thank you.
We have an existing code base that makes use of SQL CLR. When trying to run against SQL Server 2014, we're receiving this error:
Error 6517: Failed to create AppDomain "xxxx.dbo[runtime].175". Could not load file or assembly 'System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Not enough storage is available to process this command. (Exception from HRESULT: 0x80070008)
I can reproduce this error on two machines, both with 16GB. The error occurs when trying to run a series of tests that load a small amount of seed data into a database.Â
At first I thought that the problem might have been due to the CLR assembly being compiled against .NET 2.0. However, I've since change the assembly to compile against .NET 4.0 with no change in the results.
Hello,I need a clarification on the mechanism of sql server fetches recordsto memory (buffer)Example: A Table ( Table1 ) having 10 Columns(column1,column2,column3,column4 etc)When SELECT column1,column2 FROM Table1 is executedWhether all columns are trasnferred to the server memory from the diskOR only column1 and column2 are read from disk to memory .My assumption is that, entire page (8K) containg the rows with all thecolunmns are transferred to the memory and from the memory the selectcolumns are displayed .Please confirmThanksM A Srinivas
Is there any faster and efficient way for exporting or unloading the data from a table (Contains about 400 to 500 million rows) into a flat or raw file. I am using SQL server 2005 and the Export Utility in SQL Server is very slow.
I've SQL Server 2005 Dev Edition and Windows Server 2003 ENT SP2. in the task manager i see that the server use 5GB out of 6GB,but when i arrange the process to see whom takes all the memory i see that the sqlservr.exe takes 150MB(he is the biggest). when i open Perfmon and look on the sqlservr.exe memory use, i see that he takes the 4.5G. i've a problem that the server use alot of cpu time to run users queries,i see that pages/sec counter is very big average between 600-800.
is there any problem with my memory? why the memory reading from the task manager is wrong? if my pages/sec counter is so big do i have a memory leaks + pressure?
I have used google and searched these forums but haven't found an answer.
Here is my problem:
I have MS SQL 2005 DB I need to backup to tape daily. I want the tape to eject (or unload) when it is complete. I know how to do it with a manual backup (simply check off the option), but there aren't any options I can see with a Maintenance Plan backup. I would rather not do a manual backup EVERY DAY.
I really don't understand why MS makes this so complicated...why would the option be in another area when you use a maintenance plan???
Getting old favourite message 'Out of Memory' when running a horizontal clustered chart with Category: 200 items Series: 200 items per Category.URL... 'By default, the report server sets WorkingSetMaximum to the amount of available memory on the computer. This value is detected when the service starts.'Â
The report has been tried on 3 large servers with 30GB & 60GB memory. The report runs on a 2008 install but not a 2008R2 install. We've created a test report that simply generates a series of data 1-n for Category and 1-n for Series where n can be set by parameter - so the issue is not to do with the volume of data or the processing required by SSMS. The report runs if the data is output to a table rather than a chart - so the issue appears to be with rendering the chart.
The chart is rendered when the Category has 200 items with a Series of 150 per Category. The report fails with Category 200 items and Series 200 per Category.
I want to be able to load and unload, byte-for-byte, a file to and from a field of data type IMAGE in a SQL Server CE database. The files are larger than 8000 bytes so IMAGE appears to be the way to go data type wise.
I'm using VB 2008 but pseudocode for any VS language would be awesome.
I was able to do this without much effort using ADODB and its stream object, fetching a recordset object and updating the appropriate data field one "chunk" of bytes at a time. I cannot for the life of me find a way of doing this using, for example, a SqlCeResultSet.
I've tried using ADODB to connect to a SqlCe SDF database file, using a connection string that I found online, and am able to write action and select queries successfully against the database... but when I try and return a recordset that is updatable, it returns an error. So no help there.
I've searched other threads in the forums, and online in general, and I've found information on loading/unloading graphic files using a memoryStream and the toArray method thereof, but this will not work as many of the files I want to load and unload as BLOBs are not graphical in nature. FileStreams do not implement the toArray method, so I can't just stream an arbitrary file's worth of bytes that way. I also do not want to change the original file in any fashion--e.g., a hash of the source file should be identical to the file after it has been loaded into the data field and then unloaded into a new file.
I am Using Sql Server 2005 enterprise edition to develop an accounting system. now i want to distribute this software to other cleints. I have created a setup which includes all the components required for the run time of the software but i dont know how to include the sql server database in it. as i know that i have created access based software i used to include the database file in the setup and it would work but in the case of sql server i dont know how to do it . is there any runtime of sql server which needs to be downloaded or any other way out.
Hello all,I m trying to add a column in my database (it is a csv file)but it is giving me following exception.------exception------------{System.Data.OleDb.OleDbException}ErrorCode: -2147467259Errors: {System.Data.OleDb.OleDbErrorCollection}HelpLink: NothingInnerException: NothingMessage: "Operation not supported on a table that contains data."Source: "Microsoft JET Database Engine"StackTrace: " atSystem.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)atSystem.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMSdbParams, Object& executeResult)at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior,Object& executeResult)at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehaviorbehavior, String method)at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()Here is my code for this.--------Code--------------Dim ConnectString As String = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:;Extended Properties=""text;HDR=Yes;FMT=Delimited"""Dim myCon As New OleDbConnection(ConnectString)TrymyCon.Open()'Debug.WriteLine("Connection Opened")Dim cmd As New OleDbCommandcmd.CommandText = "ALTER TABLE [sample.csv] ADD mycol VARCHAR(50) NULL"cmd.Connection = myConcmd.ExecuteNonQuery()Catch ex As OleDbExceptiondebug.WriteLine(ex.Message)FinallymyCon.Close()End TryAny known reasons and workarounds????Thanks & Regards.
Hello, Im doing research for my company for a project we are about to start, but the more I find, the more Im confusing myself. Maybe someone would be so nice to help me a little.
We need a database solution, either licensing (ISV) or i think maybe an embedded database. if its licensing, its not a problem, but after research, im thinking licensing would be a waste of time or too much and theire not enough information to go by just that.
Problem: Need to develop software for a client where there will be around 300 users using the system (not all at once neccisarrily). We are creating this software for them and they want to re-sell it after completion, but they do not want to make their customers purchase a database for the purchase of their software. (because of all types of licensing). We need the database RUNTIME to run on the customers machine to make the software work.
Is there a RUNTIME license for Independant-Software-Vendor(IVS) for redistribution? or would it make sense to embed a database ( for example, the free edition of sql server;embeeded feature :), or maybe firebird embedded database?) We are developing in Visual Studio 2005.
This might sound confusing, thats where im at. For those of you with more experience, hopefully you understand what im talking about.
Thank you. I have 2 days to find a solution. Ill continue looking and post in thread if i find anything new or clearify my problem.
In both VB6 and VB2005 Both are loaded on same computer. When attempting to write to an access database table using ADO I get a runtime error: -2147217887(80040e21) "mutiple-step operation generates errors. Check each status value. " Reading the database is no problem. I only get the errors when writting to database. I have used the following code forever in VB6 and never got this error. Now that I have Visual Studio 2005 loaded on the same machine. I get this error. I get the exact same error when using this code in VB2005. I know VB6 but am just learning 2005. The following code is writting to a database table from various user imputed text and combo boxes. I used basicly the same code in VB2005 and get the same exception error. This code works on machines that do not have VB .net loaded. How do I fix this. My application is useless unless the user can make changes to their data.
Public Function ActionToDb() Dim noPo As Integer Dim SQL As String, rst As ADODB.Recordset, dataSourceName As String
Set rst = New ADODB.Recordset With rst SQL = "Select [mLVbuNo], [mStratInit], [mMerticLv],[mSubMetLv],[mTaskAction],[mImpact]," & _ "[mStatus], [mOwner], [mTitle],[mOrigDate],[mCurrentDate],[mCopmpleteDt],[mComment],[mSource]," & _ "[mStatColor],[mHyperlink],[CompCheck] From [tblMasterActionItem]" .CursorLocation = adUseClient .Open SQL, dbConn, adOpenKeyset, adLockBatchOptimistic, adCmdText noPo = .RecordCount 'If .RecordCount > 0 Then .MoveLast .AddNew rst.Fields("mLVbuNo") = giRecNo rst.Fields("mStratInit") = frmActionDe.cboStatInit.Text rst.Fields("mMerticLv") = frmActionDe.cboMetricLever.Text rst.Fields("mSubMetLv") = frmActionDe.cboSubMet.Text rst.Fields("mTaskAction") = frmActionDe.txtTask.Text rst.Fields("mImpact") = frmActionDe.txtImpact.Text rst.Fields("mStatus") = frmActionDe.txtStatus.Text rst.Fields("mOwner") = frmActionDe.cboOwn.Text rst.Fields("mTitle") = gstOwnT rst.Fields("mOrigDate") = frmActionDe.txtOrigDt.Text rst.Fields("mCurrentDate") = frmActionDe.txtCurDt.Text rst.Fields("mCopmpleteDt") = frmActionDe.txtCompDt.Text rst.Fields("mComment") = frmActionDe.txtComments.Text rst.Fields("mSource") = frmActionDe.cboSource.Text rst.Fields("mStatColor") = frmActionDe.txtStatColor.Text rst.Fields("mHyperlink") = frmActionDe.txtHyperlink.Text If optCompCheck.Value = True Then rst.Fields("CompCheck") = True Else rst.Fields("CompCheck") = False End If 'End If .Update .Close End With dbConn.Close
ExitSub: On Error Resume Next dbConn.Close Set rst = Nothing Set dbConn = Nothing Exit Sub ErrorHandler: WriteToErrorLogEnd Err.Description & " in ActionToDb" Resume
I am having a Data flow task in For each loop which will gets 100 sourcetable names and 100 target table names...
am having a simpleData flow task which trasferes from OLEDBSource to OLEDBDestination. I am repeating the Dataflow task which transfers from sourcetablename extracted from for loop to a destination table var.
The problem am gettting is for the first table it is able to transfer correcly because I did mapping for those tables at design time...but for the next coming sourcetable-desttable (which r having different no of cols,datatypes) its giving Validation failed...and...needs to refresh metadata....
is there any way to refresh the metadata of Data flow task (I set the property of OLEDBSource validate external meta to false then also same error is coming)
