Hi all,
I am running Sql 7.0 with sp2. I have a memory 4GB. When i am running some batch jobs and replications i am getting following error number:
ERROR NUMBER : 8645
A time out occurred while waiting for memory resources to execute the query. Rerun the query.
Can anyone suggest me how i have to resolve the above error, because i was facing this error very often. Pls suggest me a permanent solution.
Thanks!
--Kavira
I have a query to refer to the data source in as400 with ODBC 'iSeries Access for Windows ODBC data source' and a linked server with 'oledb for ODBC driver' in SQL2005 (9.0.2047)
Now we got 2 problems,
1. When we refer to the view with openquery e.g select * from openquery (abc, 'select * from dates')
This query continue to run without ending. In Activity monitor, we found that it is waiting for resource ole db
2. Since the process continue to run without ending, I kill the process in activity monitor or by command 'kill'. It shows the status 'KILLED/ROLLBACK' and it returns 'SPID 197: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.' in 'kill 197 with STATUSONLY'
In problem 1, I found some ppl encountered the same problem (waiting for resource oledb) with openquery to different data source e.g. vfp, oracle.
In problem 2, we can't restart the sql server for clear the unkillable process
Kindly advise. Thanks in advance.
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.
Does anybody know what might cause the following message to show up inthe SQL Server Error Log?:Time out occurred while waiting for buffer latch type 2, bp0x12260f80, page (5:77914), stat 0x40d, object ID 7:421576540:0,waittime 500. Continuing to wait.I've read several articles about what to do about this situation onSQL Server 2000, but I'm running SQL Server 7.0. Specifically, I'mrunning version 7.00.842. Is there a way to resolve this problemwithout upgrading to some flavor of SQL Server 2000?
View 2 Replies View RelatedI am attempting to modify the ADS sample to work with my own application and am running into a snag. I have a simple sqlce database that has two tables in it. I have everything working up until the point where I try to "Pull" the data. At this point in time this is what happens.
1.) I successfully Drop Table1 from the SQLCE database and then Pull "Table1" from the desktop database
2.) When attempting to Pull Table2. It runs the DoesTableExist Function, identifies that the table does exist and therefore tries to run the "DropTable" routine before Pulling the desktop Table2 data. As soon as the sqlCmd.ExecuteNonQuery of the DropTable routine runs I get the following error....
"The system timed out waiting for a lock. [ Session id = 1,Thread id = 1318094114,Process id = 1318068802,Table name = Table2,Conflict type = x lock (s blocks),Resource = DDL ][Table2]"
Of Note...I converted the sample to VB.NET so it's possible something didn't convert right? My guess is that it probably has something to with my SQLCE Database but I haven't the slightest clue where to go from there. Anyone have any ideas what might be going on?
Thanks,
Mike
SQL agent is using NT login with all permission & agent and sqlserver using the same NT username . SA password has not been changed for more than one year.
The SQL Server agent log is showing "waiting to recover database". What could be the reason ?
------------
Ray Miao at 6/5/2002 8:13:38 AM
Double check with sql service manager. Did you change sa pwd?
------------
Shaji at 6/5/2002 4:36:16 AM
Hi ,
Whenever I restart the Server , SQL server service is starting properly, but the agent is showing the green sign in EM ,agent Log also its showing its started. But in EM the jobs are not showing the next run time its showing ( Date and time not available). When I double click the jobs its showing the following error message
Micorsoft SQL - DMO ( ODBC Sql state 42000)
Error 14258 : can not perform this operation while SQL server agent is starting)
FYI :This server contain the databases of SMS too .
Thank you ,
Shaji
Hello,
I've MS SQL Server 7.0 Standard Edition and SP 2, I've configured dynamic memory, The server has 1310116K physical memory, SQL is currently using 913852K, How can I find out that which process is using so much of memory.
Thanks for help
Danny
Hello,
On my production server I've 523MB Ram, How much memory should I have on my server .
Thanks
Priti
We have two instances of SQL Server 2005 - SP1 installed on one server. The default instance starts very slowly. When looking at the log I can see the delay is due to Resource Manager based upon the following error.
Message
Resource Manager Creation Failed: 0x8004d102(XACT_E_DUPLICATE_GUID)
What does this mean?
What would cause this to happen?
How do I resolve the problem?
Thanks, Dave
we are using sql server 2005 standard edition with sp1
From last couple of days, I am getting lot of these errors-
Process 304 unlocking unowned resource: OBJECT: 2:792809934:0
Process ID 304 attempted to unlock a resource it does not own: OBJECT: 2:792809934:0 . Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator.
A user request from the session with SPID 304 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
SqlDumpExceptionHandler: Process 304 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2007-05-23 05:31:58.74 spid76 * *******************************************************************************
2007-05-23 05:31:58.74 spid76 *
2007-05-23 05:31:58.74 spid76 * BEGIN STACK DUMP:
2007-05-23 05:31:58.74 spid76 * 05/23/07 05:31:58 spid 76
2007-05-23 05:31:58.74 spid76 *
2007-05-23 05:31:58.74 spid76 *
2007-05-23 05:31:58.74 spid76 * Exception Address = 00000000015F4502 Module(sqlservr+00000000005F4502)
2007-05-23 05:31:58.74 spid76 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2007-05-23 05:31:58.74 spid76 * Access Violation occurred reading address 0000000000000018
2007-05-23 05:31:58.74 spid76 * Input Buffer 68 bytes -
2007-05-23 05:31:58.74 spid76 * 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00
2007-05-23 05:31:58.74 spid76 * S G L M e s 01 00 00 00 15 00 53 00 47 00 4c 00 4d 00 65 00 73 00
2007-05-23 05:31:58.74 spid76 * s a g e Q u e u e 73 00 61 00 67 00 65 00 51 00 75 00 65 00 75 00 65 00
2007-05-23 05:31:58.74 spid76 * S e l e c t 53 00 65 00 6c 00 65 00 63 00 74 00 00 00
2007-05-23 05:31:58.74 spid76 *
2007-05-23 05:31:58.74 spid76 *
2007-05-23 05:31:58.74 spid76 * MODULE BASE END SIZE
2007-05-23 05:31:58.74 spid76 * sqlservr 0000000001000000 00000000035FBFFF 025fc000
2007-05-23 05:31:58.74 spid76 * ntdll 0000000078EC0000 0000000078FF8FFF 00139000
2007-05-23 05:31:58.74 spid76 * kernel32 0000000078D40000 0000000078EB1FFF 00172000
2007-05-23 05:31:58.74 spid76 * MSVCR80 0000000078130000 00000000781FEFFF 000cf000
2007-05-23 05:31:58.74 spid76 * msvcrt 000007FF7FC00000 000007FF7FC85FFF 00086000
2007-05-23 05:31:58.74 spid76 * MSVCP80 000000007C420000 000000007C530FFF 00111000
2007-05-23 05:31:58.74 spid76 * ADVAPI32 000007FF7FEE0000 000007FF7FFE4FFF 00105000
2007-05-23 05:31:58.74 spid76 * RPCRT4 000007FF7FD30000 000007FF7FED8FFF 001a9000
2007-05-23 05:31:58.74 spid76 * USER32 0000000078C30000 0000000078D3BFFF 0010c000
2007-05-23 05:31:58.74 spid76 * GDI32 000007FF7FC90000 000007FF7FD28FFF 00099000
2007-05-23 05:31:58.74 spid76 * CRYPT32 000007FF7D180000 000007FF7D2DEFFF 0015f000
2007-05-23 05:31:58.74 spid76 * MSASN1 000007FF7D150000 000007FF7D179FFF 0002a000
2007-05-23 05:31:58.74 spid76 * Secur32 000007FF7E7F0000 000007FF7E811FFF 00022000
2007-05-23 05:31:58.74 spid76 * MSWSOCK 000007FF76FE0000 000007FF7705BFFF 0007c000
2007-05-23 05:31:58.74 spid76 * WS2_32 000007FF77150000 000007FF7717FFFF 00030000
2007-05-23 05:31:58.74 spid76 * WS2HELP 000007FF77140000 000007FF7714BFFF 0000c000
2007-05-23 05:31:58.74 spid76 * USERENV 000007FF7C4A0000 000007FF7C5A8FFF 00109000
2007-05-23 05:31:58.74 spid76 * opends60 00000000333E0000 00000000333E7FFF 00008000
2007-05-23 05:31:58.74 spid76 * NETAPI32 000007FF771B0000 000007FF77247FFF 00098000
2007-05-23 05:31:58.74 spid76 * SHELL32 000007FF7F190000 000007FF7FB97FFF 00a08000
2007-05-23 05:31:58.74 spid76 * SHLWAPI 000007FF7EF60000 000007FF7EFFAFFF 0009b000
2007-05-23 05:31:58.74 spid76 * comctl32 0000000000AF0000 0000000000C76FFF 00187000
2007-05-23 05:31:58.74 spid76 * psapi 000007FF7E1B0000 000007FF7E1BFFFF 00010000
2007-05-23 05:31:58.74 spid76 * instapi 0000000048060000 000000004806CFFF 0000d000
2007-05-23 05:31:58.74 spid76 * CLUSAPI 000007FF7B1C0000 000007FF7B1E3FFF 00024000
2007-05-23 05:31:58.74 spid76 * ole32 000007FF7ECE0000 000007FF7EF51FFF 00272000
2007-05-23 05:31:58.74 spid76 * OLEAUT32 000007FF7E9F0000 000007FF7EB03FFF 00114000
2007-05-23 05:31:58.74 spid76 * RESUTILS 000007FF7B310000 000007FF7B32BFFF 0001c000
2007-05-23 05:31:58.74 spid76 * sqlevn70 000000004F610000 000000004F7A3FFF 00194000
2007-05-23 05:31:58.74 spid76 * SQLOS 00000000344D0000 00000000344D5FFF 00006000
2007-05-23 05:31:58.74 spid76 * NTMARTA 000007FF7E2F0000 000007FF7E32BFFF 0003c000
2007-05-23 05:31:58.74 spid76 * SAMLIB 000007FF76F80000 000007FF76F95FFF 00016000
2007-05-23 05:31:58.74 spid76 * WLDAP32 000007FF7E780000 000007FF7E7E5FFF 00066000
2007-05-23 05:31:58.74 spid76 * rsaenh 000000000FFB0000 000000000FFEDFFF 0003e000
2007-05-23 05:31:58.74 spid76 * AUTHZ 000007FF7E2C0000 000007FF7E2ECFFF 0002d000
2007-05-23 05:31:58.74 spid76 * MSCOREE 000006427EE60000 000006427EED3FFF 00074000
2007-05-23 05:31:58.75 spid76 * msv1_0 000007FF7E330000 000007FF7E373FFF 00044000
2007-05-23 05:31:58.75 spid76 * iphlpapi 000007FF57250000 000007FF57280FFF 00031000
2007-05-23 05:31:58.75 spid76 * kerberos 000007FF77410000 000007FF774C2FFF 000b3000
2007-05-23 05:31:58.75 spid76 * cryptdll 000007FF7DAB0000 000007FF7DABEFFF 0000f000
2007-05-23 05:31:58.75 spid76 * schannel 000007FF7DB70000 000007FF7DBB0FFF 00041000
2007-05-23 05:31:58.75 spid76 * COMRES 000007FF7E920000 000007FF7E9E5FFF 000c6000
2007-05-23 05:31:58.75 spid76 * XOLEHLP 000007FF5C560000 000007FF5C566FFF 00007000
2007-05-23 05:31:58.75 spid76 * MSDTCPRX 000007FF67140000 000007FF67210FFF 000d1000
2007-05-23 05:31:58.75 spid76 * msvcp60 000000000AD30000 000000000AE19FFF 000ea000
2007-05-23 05:31:58.75 spid76 * MTXCLU 000007FF7B540000 000007FF7B569FFF 0002a000
2007-05-23 05:31:58.75 spid76 * VERSION 000007FF7FBF0000 000007FF7FBFAFFF 0000b000
2007-05-23 05:31:58.75 spid76 * WSOCK32 000007FF770F0000 000007FF770F9FFF 0000a000
2007-05-23 05:31:58.75 spid76 * DNSAPI 000007FF7E720000 000007FF7E76DFFF 0004e000
2007-05-23 05:31:58.75 spid76 * winrnr 000007FF7E820000 000007FF7E82AFFF 0000b000
2007-05-23 05:31:58.75 spid76 * rasadhlp 000007FF7E830000 000007FF7E836FFF 00007000
2007-05-23 05:31:58.75 spid76 * hnetcfg 000007FF6D1F0000 000007FF6D280FFF 00091000
2007-05-23 05:31:58.75 spid76 * wshtcpip 000007FF76FA0000 000007FF76FAAFFF 0000b000
2007-05-23 05:31:58.75 spid76 * security 000007FF77530000 000007FF77534FFF 00005000
2007-05-23 05:31:58.75 spid76 * msfte 0000000049980000 0000000049D2DFFF 003ae000
2007-05-23 05:31:58.75 spid76 * dbghelp 000000000D7F0000 000000000D949FFF 0015a000
2007-05-23 05:31:58.75 spid76 * WINTRUST 000007FF7E210000 000007FF7E25DFFF 0004e000
2007-05-23 05:31:58.75 spid76 * imagehlp 000007FF7E2A0000 000007FF7E2B2FFF 00013000
2007-05-23 05:31:58.75 spid76 * dssenh 000000000FF70000 000000000FFABFFF 0003c000
2007-05-23 05:31:58.75 spid76 * ntdsapi 000007FF7DAD0000 000007FF7DAF3FFF 00024000
2007-05-23 05:31:58.75 spid76 * xpsp2res 000007FF5C210000 000007FF5C4D6FFF 002c7000
2007-05-23 05:31:58.75 spid76 * CLBCatQ 0000000003600000 00000000036DDFFF 000de000
2007-05-23 05:31:58.75 spid76 * sqlncli 00000000337A0000 0000000033A5DFFF 002be000
2007-05-23 05:31:58.75 spid76 * COMCTL32 0000000003700000 00000000037EDFFF 000ee000
2007-05-23 05:31:58.75 spid76 * comdlg32 000007FF7D360000 000007FF7D3D6FFF 00077000
2007-05-23 05:31:58.75 spid76 * SQLNCLIR 0000000035000000 0000000035032FFF 00033000
2007-05-23 05:31:58.75 spid76 * msftepxy 000000000F130000 000000000F150FFF 00021000
2007-05-23 05:31:58.75 spid76 * xpstar90 0000000053C30000 0000000053CB4FFF 00085000
2007-05-23 05:31:58.75 spid76 * SQLSCM90 0000000053AD0000 0000000053ADBFFF 0000c000
2007-05-23 05:31:58.75 spid76 * ODBC32 000007FF63EB0000 000007FF63F16FFF 00067000
2007-05-23 05:31:58.75 spid76 * BatchParser90 00000000520C0000 00000000520ECFFF 0002d000
2007-05-23 05:31:58.75 spid76 * ATL80 000000007C630000 000000007C64DFFF 0001e000
2007-05-23 05:31:58.75 spid76 * odbcint 000007FF63DC0000 000007FF63DD7FFF 00018000
2007-05-23 05:31:58.75 spid76 * xpstar90 0000000010CC0000 0000000010CE5FFF 00026000
2007-05-23 05:31:58.75 spid76 * msxmlsql 0000000078800000 0000000078963FFF 00164000
2007-05-23 05:31:58.75 spid76 * msxml3 000007FF78A20000 000007FF78C2DFFF 0020e000
2007-05-23 05:31:58.75 spid76 * xpsqlbot 000000004A7C0000 000000004A7C7FFF 00008000
2007-05-23 05:31:58.75 spid76 * xplog70 0000000034730000 000000003473FFFF 00010000
2007-05-23 05:31:58.75 spid76 * xplog70 00000000125B0000 00000000125B2FFF 00003000
2007-05-23 05:31:58.75 spid76 *
2007-05-23 05:31:58.75 spid76 * P1Home: FFFFFADEC275F600:
2007-05-23 05:31:58.75 spid76 * P2Home: 0000000017F4DEA0: FFFFFADEC275F600 0000000017F4DEA0 0000000000000000 0000000017F4E660 0000800000000000 FFFFFADEC275F940
2007-05-23 05:31:58.75 spid76 * P3Home: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * P4Home: 0000000017F4E660: FFFFFFFF00000001 0000000000000000 0000000100ECCEA8 0000000100ECCF60 0000000000000000 00000000E226E9C0
2007-05-23 05:31:58.75 spid76 * P5Home: 0000800000000000:
2007-05-23 05:31:58.75 spid76 * P6Home: FFFFFADEC275F940:
2007-05-23 05:31:58.75 spid76 * ContextFlags: 000000000010001F:
2007-05-23 05:31:58.75 spid76 * MxCsr: 0000000000001FA0:
2007-05-23 05:31:58.75 spid76 * SegCs: 0000000000000033:
2007-05-23 05:31:58.75 spid76 * SegDs: 000000000000002B:
2007-05-23 05:31:58.75 spid76 * SegEs: 000000000000002B:
2007-05-23 05:31:58.75 spid76 * SegFs: 0000000000000053:
2007-05-23 05:31:58.75 spid76 * SegGs: 000000000000002B:
2007-05-23 05:31:58.75 spid76 * SegSs: 000000000000002B:
2007-05-23 05:31:58.75 spid76 * EFlags: 0000000000010202: 0065002E0064006D 0046000000650078 004F004E005F0050 0053004F0048005F 00480043005F0054 003D004B00430045
2007-05-23 05:31:58.75 spid76 * Rax: 0000000100ECCF60: 0000000000000000 0000000100ECCEA8 0000000000000000 0065006300630041 0000000000000000 0000000000000000
2007-05-23 05:31:58.75 spid76 * Rcx: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * Rdx: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * Rbx: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * Rsp: 0000000017F4E440: 0000000001B30DC0 FFFFFFFFFF000000 0000000000000000 0000000078D6E31C 00000000D44421C0 00000000015E8750
2007-05-23 05:31:58.75 spid76 * Rbp: 0000000017F4E660: FFFFFFFF00000001 0000000000000000 0000000100ECCEA8 0000000100ECCF60 0000000000000000 00000000E226E9C0
2007-05-23 05:31:58.75 spid76 * Rsi: 0000000273C15900: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2007-05-23 05:31:58.75 spid76 * Rdi: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * R8: 00000000D44421C0: 0000000000000000 0000000000000000 00000000D039C1D0 00000000E892C1D0 0000000000000001 00000000038203A0
2007-05-23 05:31:58.75 spid76 * R9: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * R10: 0000000001000000: 0000000300905A4D 0000FFFF00000004 00000000000000B8 0000000000000040 0000000000000000 0000000000000000
2007-05-23 05:31:58.75 spid76 * R11: 0000000017F4E5C8: 00000000015E5847 00000000063C8080 00000000063C8130 0000000192CED0F0 0000000001541382 FFFFFFFFFFFF0002
2007-05-23 05:31:58.75 spid76 * R12: 0000000017F4E608: 00000000063C4C58 0000000000000000 0000000000000000 00000000000002AA 0000000017F4E890 0000000100ECCE70
2007-05-23 05:31:58.75 spid76 * R13: 0000000000000001:
2007-05-23 05:31:58.75 spid76 * R14: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * R15: 0000000000000000:
2007-05-23 05:31:58.75 spid76 * Rip: 00000000015F4502: 086F8B4C187A8B48 C1F6434FB60F2074 44004E814E850F02 0F04C1F660244C89 4C894C004E815985 30250C8B48657824
2007-05-23 05:31:58.75 spid76 * *******************************************************************************
2007-05-23 05:31:58.75 spid76 * -------------------------------------------------------------------------------
2007-05-23 05:31:58.75 spid76 * Short Stack Dump
2007-05-23 05:31:58.75 spid76 00000000015F4502 Module(sqlservr+00000000005F4502)
2007-05-23 05:31:58.75 spid76 00000000015E5847 Module(sqlservr+00000000005E5847)
2007-05-23 05:31:58.75 spid76 000000000158A7CE Module(sqlservr+000000000058A7CE)
2007-05-23 05:31:58.75 spid76 00000000024796E7 Module(sqlservr+00000000014796E7)
2007-05-23 05:31:58.75 spid76 000000000247A0E5 Module(sqlservr+000000000147A0E5)
2007-05-23 05:31:58.75 spid76 0000000001A2F32F Module(sqlservr+0000000000A2F32F)
2007-05-23 05:31:58.75 spid76 0000000001625988 Module(sqlservr+0000000000625988)
2007-05-23 05:31:58.75 spid76 0000000001736E0B Module(sqlservr+0000000000736E0B)
2007-05-23 05:31:58.75 spid76 000000000161BC5B Module(sqlservr+000000000061BC5B)
2007-05-23 05:31:58.75 spid76 00000000016126D1 Module(sqlservr+00000000006126D1)
2007-05-23 05:31:58.75 spid76 0000000001614BB6 Module(sqlservr+0000000000614BB6)
2007-05-23 05:31:58.75 spid76 000000000268C3CA Module(sqlservr+000000000168C3CA)
2007-05-23 05:31:58.75 spid76 000000000268DCB4 Module(sqlservr+000000000168DCB4)
2007-05-23 05:31:58.75 spid76 000000000161FC5E Module(sqlservr+000000000061FC5E)
2007-05-23 05:31:58.75 spid76 00000000015C80E8 Module(sqlservr+00000000005C80E8)
2007-05-23 05:31:58.75 spid76 00000000015CAD6D Module(sqlservr+00000000005CAD6D)
2007-05-23 05:31:58.75 spid76 00000000015E0232 Module(sqlservr+00000000005E0232)
2007-05-23 05:31:58.75 spid76 00000000015DE73E Module(sqlservr+00000000005DE73E)
2007-05-23 05:31:58.75 spid76 00000000015D66CE Module(sqlservr+00000000005D66CE)
2007-05-23 05:31:58.75 spid76 00000000015D7129 Module(sqlservr+00000000005D7129)
2007-05-23 05:31:58.75 spid76 00000000015CE674 Module(sqlservr+00000000005CE674)
2007-05-23 05:31:58.75 spid76 00000000014CE4C7 Module(sqlservr+00000000004CE4C7)
2007-05-23 05:31:58.75 spid76 00000000017A0B89 Module(sqlservr+00000000007A0B89)
2007-05-23 05:31:58.75 spid76 0000000001785C90 Module(sqlservr+0000000000785C90)
2007-05-23 05:31:58.75 spid76 00000000017D08F8 Module(sqlservr+00000000007D08F8)
2007-05-23 05:31:58.75 spid76 00000000781337A7 Module(MSVCR80+00000000000037A7)
2007-05-23 05:31:58.77 spid76 0000000078133864 Module(MSVCR80+0000000000003864)
2007-05-23 05:31:58.77 spid76 0000000078D6B66A Module(kernel32+000000000002B66A)
Can anyone help me these errors? Why I am getting these errors ? And how do i resolve this issue?
Thanks
OK heres the deal, I just purchased a new dell and uninstalled the sql server. Now i am getting- Execution cannot continue as the language dependent resource fil could not be loaded. Any ideas where i could download it or where to get some answers??? My laptop is only 3months old what the fudge!!!!!!!!!!!
View 2 Replies View RelatedI have a Sql Server 2000 on win2000 advanced server with 2GB of memory.
Currently it is set to use 1.75Gb by setting max memory option
I am planning to add 1 GB memory to it and want to allocate 2.6 GB to sql server and rest to the OS.
Is this possible ?
I have read articles that if you have 3gb of memory the maximum you can allocate to sql is 2Gb?
Thanks
I have a page that was working but now I am getting the following errors.
Server Error in '/' Application.
ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded.ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.Odbc.OdbcException: ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded.ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended PropertiesERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDRERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMTERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[OdbcException (0x80131937): ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded.
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR
ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT
ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded.]
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +35
System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) +131
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +98
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.Odbc.OdbcConnection.Open() +37
DevSite_ImportStep1.btnUpload_Click(Object sender, EventArgs e) +219
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
I am uploading a text file to a MS SQL 2000 database using an ODBC driver. Here is the code:
<code>
FileUpload1.SaveAs(fpath + "" + fn)
litStep1.Visible = TrueDim FieldCount As Int16
Dim FileType As Int16Dim cmd As SqlCommand
Dim dr As SqlDataReaderDim conn2 As OdbcConnection
Dim dr2 As OdbcDataReader
Dim cmd2 As OdbcCommand
conn2 = New OdbcConnection("Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + fpath + ";Extended Properties='text;HDR=YES;FMT=Delimited'")
conn2.ConnectionTimeout = 200
cmd2 = New OdbcCommand("Select top 5 * from [" + fn + "] ", conn2)
cmd2.CommandType = CommandType.Text
cmd2.CommandTimeout = 300
conn2.Open()
dr2 = cmd2.ExecuteReader()
FieldCount = dr2.FieldCount
conn2.Close()
</code>
Before when this happened a reboot of the sql server resolved the problem. That's not working this time and it's certainly not a practical solution.
Any suggestions?
We have two instances of SQL Server 2005 - SP1 installed on one server. The default instance starts very slowly. When looking at the log I can see the delay is due to Resource Manager based upon the following error.
Message
Resource Manager Creation Failed: 0x8004d102
(XACT_E_DUPLICATE_GUID)
What does this mean?
What would cause this to happen?
How do I resolve the problem?
Thanks, Dave
I am using SQL 2000 (Standard Edition, SP4) and have created a linked server to access a Access MDB file. When I run a simple query against that server, I get the error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: System resource exceeded.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' ICommandText::Execute returned 0x80004005: ].
I am able to connect to this same Access MDB file from another SQL server (SQL 2000 Enterprise Edition, SP4). I have compared the two servers and they both have the same version of MDAC (2.8) and the same version of the Jet OLE DB Provider.
Any idea why this would work from one server and not from the other. Also, I was able to perform the same queries from the first server a week back.
Thanks in advance for you help.
Amir
While I was out of the office the Lan Team moved one of my SQL Server2000 servers to a new network domain. Since then the maintenance jobhas not ran.The error log for the SQL Agents has the message listed in the subjectline. I have not found any useful articles on the MS SQL Serversite. Anyone know what might be wrong and how to fix it.HTH -- Mark D Powell --
View 4 Replies View RelatedHi all
After deploying my report on the report Server, I try to access it on the browser which gives me the following error.
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
A name was started with an invalid character. Error processing resource 'http://localhost/reports/Pages/Folder.aspx'. Line...<%@ Page language="c#" Codebehind="Folder.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.Folde...
How can I trouble shoot this error.?
Please help me out.
Thanx in advance.
Ronald
Hi,
I am trying to execute a SSIS package from a client through BIDS, but when I start BIDS, I am getting the error -
SqlWb.exe : Application error - The instruction at "0X77D...." referenced memory at "0X00000002". The memory could bot be "read".
Click on OK to terminate the program.
Click on CANCEL to terminate the program.
Please help.
Other information:
I have tried running the package on the server and it executes properly. I really dont know why this is a problem with the SQL Server clients alone. I have also tried googling around and could not find any resolution. Can anyone point me to the right direction please!!!
Thanks in advance!!!
We are having a problem with an SSIS package. The package gets stuck when it runs a data flow component that reads data from 5 large tables, performs a union on the data, does a conversion on one field and then writes the data to another table. This all happens in the same database and the ssis package runs on the same server as the database.
When I look at the waiting tasks on the sql server I always see the following type of scenario. It is always the ASYNC_NETWORK_IO that is causing the others to wait.
SPID
Wait type
duration
Waiting Address
Blocking Address
118
ASYNC_NETWORK_IO
47
0x0000000000C2FD68
NULL
118
CXPACKET
47
0x0000000000C2F2E8
0x0000000000C2FD68
118
CXPACKET
47
0x0000000000EB4DA8
0x0000000000C2FD68
118
CXPACKET
47
0x0000000000ECB048
0x0000000000C2FD68
118
CXPACKET
47
0x0000000000EE12E8
0x0000000000C2FD68
In some cases the duration column goes up to several hours until we finally just kill the package. At the same time, we also see that session 118 is consuming very large amounts of memory (in sys.dm_exec_query_memory_grants). However, when we look at the dtexec process that is running the package on the server it only has a working set of about 100Mb. We've tried rewriting the dataflow task as a simple stored procedure and this goes through smoothly.
Can anyone shed some light on what is going on and how to avoid this type of locking situation (other than just using plain old T-SQL).
We have a two node cluster running W2K and SQL2000. The agent starts, but we cannot access any of the jobs. It gives us the 14258 Agent is starting, try again later... error message. We know that this is not the case, we have waited several hours without it "starting". The SQL Agent log indicates that the agent is waiting on SQL Server to recover databases, but all of our databases are up. It is almost as if during startup a flag did not get set to indicate that a database was recovered.
Has anyone run across this before? If so, did you ever figure out how to fix it?
is there a way to automate a job to wait on a flag in a directory and to start my maintenance plans ?
if so how would i code is there external functions plz help.
I have a Stored Procedure which Ideally should run when a Customer Logs in, the Procedure will check the available stock and create a Temp Table for the Information, which allows many other Queries in the site to run a lot faster, (due to no joins). The Query has taken as much as 30seconds (Lots of Records and 1/2 dozen Joins) to run upon log in and causing a Timeout for the web application.
I want the procedure to run as it is, but for the login method to not be dependent on the Process tried this in .NET cmd.BeginExecuteNonQuery() (cmd=SQLCOmmand)
which doesn't do what I want it just allows me to run heaps of QUeries at the same time.
Can anyone help me with getting this procedure to run and not hold up the Web application? Not sure whether I need to do this in .NET, or whether I can get .NET to run a Batch File or something, but someone must have had a similiar problem, please help.
DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.CREATE PROCEDURE [dbo].[spu_Import_Export_Image](@srvr varchar(50),@db varchar(50),@usr varchar(15),@pwd varchar(50),@tbl varchar(50),@col varchar(50),@mod varchar(1),@imgpath1 varchar(1000),@pk varchar(50))ASBEGINdeclare @path varchar(50)declare @whr varchar(200)declare @fil varchar(100)declare @cmd varchar(1000)declare @imgpath varchar(800)declare @ext varchar(5)--declare @pk varchar(50)declare @KeyValue varchar(8000)declare @image varchar(50)--declare @imgpath1 varchar(1000)declare @imgpath2 varchar(1000)declare @sellist varchar(2000)set @path = 'c: extCopy.exe'select @sellist = 'DECLARE curKey CURSOR FOR SELECT ' + @pk +' FROM '+ @tbl + ' ORDER BY ' + @pkexec (@sellist)OPEN curKeyFETCH NEXT FROM curKey INTO @KeyValueWHILE (@@fetch_status = 0)BEGINset @whr = '"where '+ @pk +' = "' + @KeyValueset @fil = @imgpath1 + '' + @KeyValue --+ @extset @cmd = @path + ' /S ' + @srvr + ' /D ' + @db + ' /U ' + @usr+ ' /P ' + @pwd+ ' /T ' + @tbl + ' /C ' + @col + ' /W ' + @whr + '/F ' + @fil+ ' /' + @modexec Master..xp_cmdShell @cmdFETCH NEXT FROM curKey INTO @KeyValueENDCLOSE curKeyDEALLOCATE curKeyENDGOAbove srcipt runs fine with image data type in one table but when irun for some other table it gives me Error MessageTEXTCOPY Version 1.0DB-Library version 8.00.194SQL Server 'WSQL01' Message 170: Line 1: Incorrect syntax near '99'.(Concerning line 1)DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.ERROR: Could not use database 'test1'NULL-----------Aslo it only runs on server console if i run it from workstation uingsame files and tables it gives me an error again. Can anybody help meand reply me at Join Bytes! asap.thnx,dharmesh
View 1 Replies View RelatedHi Guys,
One of your SQLSERVER 7, Server throws the below error message into the log file. It won't go away until the server get rebooted. When this error start showing up.. customers have hard time connecting to the Server, eventually we have to reboot the server.
Time out occurred while waiting for buffer latch type 1, bp 0x18b9200, page (1:50859), stat 0xb, object ID 17:1954106002:1, waittime 500. Continuing to wait.
Any help is greatly appericated.
thanks
Is anyone have already encountered such a problem :
When a table is locked by several locks (key, pag), either a SELECT request which does not need to lock any row cannot succeed.
In SQL Server Enterprise Manager, I see that my request is waiting for a lock "LCK_M_S" !!!
How I can avoid this kind of situation which seems to me completely abnormal.
I have never been faced with this kind of problem in Oracle.
Thanks for anyone who will help me to resolve this "bug".
I'm wondering if there is any way for me to execute any type of command (delete, insert, create, alter, etc) on management studio without having to wait the server answer.
On Oracle, I use DBMS_JOB. On SQL Server, do I have to create a SQL SERVER Agent Job? What if I don't have permission to create that kind of jobs?
Hi!
I hope to get some help with a stored procedure that never stops executing when run from Reporting Services development environment.
The server: SQL Server 2005 SP2 x86, 2 gig ram, 2 processor cores.
The stored procedure I execute is simple, it declares and sets some variables and then a executes a select statement
with 6 joins.
If I execute the stored procedure from Management Studio the query runs and returns about 50 000 rows in ~2 seconds. No problems!
The problems arises when I execute the stored procedure from visual studio (testing my reporting services report). The query will never complete its execution!?
I checked the activity monitor and can verify I have NO processses with any information in the blocked by or blocking column.
The strange thing is I got 3 rows for process id 64, only one row (row 1) printing the executing user.
Row 1: Stutus suspenden, Wait Type CXPACKET
Row 2 and 3 are pending between runnable and suspended and wait typoe pageiolatch_ex and no wait type at all when I refresh. These are probably parallell threads executed in the query.
The strange thing here is that this process never completes and if I do a trace the last command executed is select statement. I don´t understand what the problem is, sql server bug? Parellelism problem (in this case, why?)
Any help is appreciated
Regards
Per
My Excel Pivot Table connects to and SSAS 2008 cube. What exactly happens in the back-end during 'Waiting for the query to be executed...'
View 3 Replies View Relatedhi!
I wonder if anyone can tell me how we can run select queries in an OLE DB data flow task and tell the target SQL 2000 server it should allow reads at all time. Currently when a lock is on the source table our SSIS package will sit and wait untill the lock on the source table is gone.
Thanks.
Marc
I am relatively new to SQL Server so excuse my ignorance.
I have noticed in many of my SQL Server 2005 instances that the tempdb database is very often reporting the log mode as waiting active_transaction or waiting checkpoint.
Is this of concern, how can I determine the cause of these waits and how can they be reduced or eliminated ?
Frequently, when I'm connecting to my server through SSMS i get "Is Busy: Microsoft SQL Server is waiting to complete an internal operation...."
And it tells me that if I get that message a lot, I should let Microsoft know.
So -- Microsoft, I'm letting you know.
Can anyone tell me why this is happening? I've searched MSDN and the knowledge base...I can only find one reference, and that is to a database diagram issue.
It takes a while to connect when this happens. So far, I haven't found a common denominator. It happens if I'm logged into my server and I try to connect to another instance, and it happens when I'm using my desktop...
Folks,
I am getting error 8645 on a two processor 1GB RAM machine with SQL server 7.0 svcpack 1 on Windows NT svcpack 4. It has a 4GB db which is used by a VB. application running on another server. Initially I left the memory setting to dynamic, getting error 8645 when more users try to access the server. Upon lot of complains I changed the memory configuration and fixed it to 800MB, other application running on the server is Seagate backupexec but the problem exists even before this application. I stopped the service just to make sure if problem occurs because of backup software. Server is completely dedicated SQL server. Number of users are set to 400. I can see average 200 connections every day but active connections are almost 20. When error pops up in SQL agent display log, users complain about screen freezing up and cannot do anything. Machine of this size should be able to handle that many users without any glitch. Page file size is 1.5GB.
After careful examination I made following changes on SQL Server
1. Configured to use "Boost SQL Server priority on Windows NT"
2. Configured to use "Use NT fibers"
3. Dropped number of connections from 500 to 400.
4. Changed memory option back to dynamic allocation.
After these options changed there was no problem for couple of days and users were happy that not a single downtime occurs.
But this morning it started to acting up again, it does not show any error message in SQL server error log but in SQL agent error log.
My questions are:
What areas I need to look into to improve performance and to avoid these memory errors?
Why these messages appearing in SQL Agent error log?
Should I apply service pack 5 on NT and service pack 2 on SQL server?
Do I need to increase RAM.
I will really appreciate if you address this problem on priority.
Thanks in advance
Adnan
I use linkedserver to get data from Oracle, but sometimes I get the error below:
Server: Msg 7399, Level 16, State 1, Procedure GetDataFromERP, Line 21
OLE DB provider 'OraOLEDB.Oracle' reported an error.
2006-02-09
[OLE/DB provider returned message: ]
[OLE/DB provider returned message: ROW-00001: Cannot allocate memory]
OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle' ICommandText::Execute returned 0x80004005: ].
I think maybe it is because the data is very large.
How do I solve this problem?