SQL Optimization Server Crash

Jun 9, 2008

Hi all, I was wondering if you's could help me out.
We run sql optimization on 2 of our databases and when they run they cause our server to crash - system log reports: unexpected shutdown. When we take these jobs out of action the server does not crash.

I'm not sure if this could be a CPU or memory related issue or if its a SQL configuration issue?

Any comments/ideas would be great.

Thanks.

View 20 Replies


ADVERTISEMENT

Table Data Retrieval And Optimization Optimization Help

Apr 10, 2008

Hello Everybody,

I have a small tricky problem here...need help of all you experts.

Let me explain in detail. I have three tables

1. Emp Table: Columns-> EMPID and DeptID
2. Dept Table: Columns-> DeptName and DeptID
3. Team table : Columns -> Date, EmpID1, EmpID2, DeptNo.

There is a stored procedure which runs every day, and for "EVERY" deptID that exists in the dept table, selects two employee from emp table and puts them in the team table. Now assuming that there are several thousands of departments in the dept table, the amount of data entered in Team table is tremendous every day.

If I continue to run the stored proc for 1 month, the team table will have lots of rows in it and I have to retain all the records.

The real problem is when I want to retrive data for a employee(empid1 or empid2) from Team table and view the related details like date, deptno and empid1 or empid2 from emp table.
HOw do we optimise the data retrieval and storage for the table Team. I cannot use partitions as I have SQL server 2005 standard edition.

Please help me to optimize the query and data retrieval time from Team table.


Thanks,
Ganesh

View 4 Replies View Related

Server Crash

Mar 27, 2001

Hi,

My Sql server went down last night. Is there a way to find out what could have caused system to crash?
Is there any way to notify the DBA when sql services have stopped running?

Any hint/suggestion is highly appreciated..

Thanks..
Ann

View 5 Replies View Related

SQL Server Crash

Jun 29, 2001

Hello,

Recently my computer had a crash on which SQL Server was installed. And if that wasn't enough, the backup failed to. Now I've installed SQL Server again, but I have these *.mdf and *.ldf files, which contains my data and my tables etc. So my question is, how do I get this data into my newly installed SQL Server? Maybe it's quite simple, but I can't find it.
Im using SQL Server Enterprise version 7.0 on Win2k Advanced Server.

Many thanks in advance,
Stefan.

View 2 Replies View Related

Server Crash

Apr 3, 2000

Hi,
My sql server stopped unexpectedly and restarted itself today, and I have no clue why. The NT Event Viewer provides this "insight":

The MSSQLService terminated unexpectedly.

The event id is 17052, which isn't documented in BOL. Does anyone have any explanation, and some suggestions on how to avoid this in the future?
thanks,
Jason

View 1 Replies View Related

Server Crash

Oct 18, 1999

Hi Folks,

I got the following message in the error log when SQL Server 6.5 crashed.
''Stored function 'xp_runwebtask' in the library 'xpsqlweb.dll' generated access violation; SQL Server is terminating process 60''
Source:spid 60
Anyone know what this means ? If you think you know of have come across it before, please inform me.

Thanks
Alan

View 1 Replies View Related

SQL Server Crash

Feb 16, 1999

I need help. I am facing following problems since days
here you have the errors messages:

Mesg 18264 : DATABASE dumped with following info: Database Name:IITMSDB, Creation Date and Time:Feb 12, 99(23:00), Pages dumped:3898618, Current Sequence:36201 19370307, Sort Order:52, Striped:NO, Number of Dump Devices:1, device info:(VOLID=SS0001 NAME=iitmsdb_dump TYPE=DISK FILE=1)

Mesg 17562 : Checking space allocation for database 6

Mesg 18109 : Recovery dbid 10 ckpt (590112,18) oldest tran=(590112,0)

Error : 0, Severity: 19, State: 0
SQLDumpExceptionHandler: Process 49 generated access violation; SQL Server is terminating this process

Error : 0, Severity: 19, State: 0
SQLDumpExceptionHandler: Process 102 generated access violation; SQL Server is terminating this process

Mesg 17309 : The current contents of process' input buffer are '_cursoropen'.

Error : 925, Severity: 19, State: 1
Maximum number of used databases for each query has been exceeded. The maximum allowed is 8.

Thanks a lot. Bangaly

View 1 Replies View Related

SQL Server Crash

Jul 3, 2007

Hi all,



I'm running on Windows Server 2000 datacenter with sp4 and SQL Server 2000 SP4 on 16 GB AWE and /PAE enabled. Apparently the SQL Server service stops intermittently.

Below is the error I got on the application log.



"SqlDumpExceptionHandler: Process 788 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."



Below is a part of the SQLdump that was created.



=====================================================================
BugCheck Dump
=====================================================================

This file is generated by Microsoft SQL Server 8.00.2040
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.

Computer type is AT/AT COMPATIBLE.
Bios Version is Phoenix ROM BIOS PLUS Version 1.10 1.1.0
Phoenix ROM BIOS PLUS Version 1.10 1.1.0
Current time is 10:27:18 07/02/07.
4 Intel x86 level 6, 2992 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.


Memory
MemoryLoad = 82%
Total Physical = 7903 MB
Available Physical = 1373 MB
Total Page File = 11795 MB
Available Page File = 5311 MB
Total Virtual = 2047 MB
Available Virtual = 296 MB

*Dump thread - spid = 72, PSS = 0x41d77260, EC = 0x41d77590
*
* User initiated stack dump. This is not a server exception dump.
*
*Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQLDu
mp0001.txt
* *****************************************************************************
**
*
* BEGIN STACK DUMP:
* 07/02/07 10:27:18 spid 72
*
* ex_raise2: Exception raised, major=79, minor=87, severity=22
*
*



Regards,

Larry

View 2 Replies View Related

Weekly Server Crash

Nov 1, 1999

Been trying to send this all week...

-----Original Message-----
From: Driggers, John
To: 'SQL Discussions'
Sent: 10/27/99 9:10 AM
Subject: FW: Weekly server hang




I also see the one below prior to another crash....going through tech
net now...but not seeing anything that reflects the messages below. The
results from searching on "Exception_Access_Violation" I'm not sure
apply in my case...also looks like I have at least two causes of crashes
(how can one interpret the below statements???)

Thanks, John
--------------------

99/10/24 10:38:00.06 spid10 EXCEPTION_ACCESS_VIOLATION raised,
attempting to create symptom dump
99/10/24 10:38:00.06 spid10 Initializing symptom dump and stack dump
facilities
99/10/24 10:38:02.61 spid10 ***BEGIN STACK TRACE***
99/10/24 10:38:02.61 spid10 0x00404CD9 in SQLSERVR.EXE,
rm_ods_handler() + 0x0329
99/10/24 10:38:02.64 spid10 0x00405571 in SQLSERVR.EXE, st_do_enlist()
+ 0x00C1
99/10/24 10:38:02.64 spid10 0x004071CA in SQLSERVR.EXE,
CDTCState::init() + 0x033A
99/10/24 10:38:02.65 spid10 0x005A70A3 in SQLSERVR.EXE,
lddb_fixdbosuid() + 0x0423
99/10/24 10:38:02.68 spid10 0x005A6CC2 in SQLSERVR.EXE,
lddb_fixdbosuid() + 0x0042
99/10/24 10:38:02.68 spid10 0x005963CB in SQLSERVR.EXE, textalloc() +
0x04CB
99/10/24 10:38:02.71 spid10 0x00463F4B in SQLSERVR.EXE, agghaving() +
0x004B
99/10/24 10:38:02.71 spid10 0x00409829 in SQLSERVR.EXE, opencheck() +
0x0089
99/10/24 10:38:02.71 spid10 0x00427B09 in SQLSERVR.EXE,
tbswritecheck() + 0x0969
99/10/24 10:38:02.71 spid10 0x00250FED in opends60.dll
99/10/24 10:38:02.71 spid10 0x0025055B in opends60.dll
99/10/24 10:38:02.71 spid10 0x002414D1 in opends60.dll
99/10/24 10:38:02.71 spid10 0x00241384 in opends60.dll
99/10/24 10:38:02.71 spid10 0x10219D84 in MSVCRT40.dll
99/10/24 10:38:02.71 spid10 0x77F04F3E in KERNEL32.dll
99/10/24 10:38:02.71 spid10 ***END STACK TRACE***

************************************************** **********************
*************

Cindy, nothing in the NT logs but found this in the SQL logs:



99/10/25 09:25:15.45 spid71 EXCEPTION_ACCESS_VIOLATION raised,
attempting to create symptom dump
99/10/25 09:25:15.45 spid71 Initializing symptom dump and stack dump
facilities
99/10/25 09:25:20.45 spid71 ***BEGIN STACK TRACE***
99/10/25 09:25:20.46 spid71 0x00404CD9 in SQLSERVR.EXE,
rm_ods_handler() + 0x0329
99/10/25 09:25:20.52 spid71 0x005725C1 in SQLSERVR.EXE, stuff() +
0x0241
99/10/25 09:25:20.54 spid71 0x0056D35F in SQLSERVR.EXE, ncrid_update()
+ 0x057F
99/10/25 09:25:20.57 spid71 0x0051DD35 in SQLSERVR.EXE, prRESOURCE() +
0x0055
99/10/25 09:25:20.57 spid71 0x00464C65 in SQLSERVR.EXE, genbuiltin() +
0x0445
99/10/25 09:25:20.59 spid71 0x00427B09 in SQLSERVR.EXE,
tbswritecheck() + 0x0969
99/10/25 09:25:20.62 spid71 0x00250FED in opends60.dll
99/10/25 09:25:20.62 spid71 0x0025055B in opends60.dll
99/10/25 09:25:20.62 spid71 0x002414D1 in opends60.dll
99/10/25 09:25:20.62 spid71 0x00241384 in opends60.dll
99/10/25 09:25:20.62 spid71 0x10219D84 in MSVCRT40.dll
99/10/25 09:25:20.62 spid71 0x77F04F3E in KERNEL32.dll
99/10/25 09:25:20.62 spid71 ***END STACK TRACE***



This proceeds my 'crashes', which it looks scary enough to do the trick!



Any idea what could be causing this exception?

Thanks, John

ps. someone else mentioned backup software - we use BackupExec and I
have a sched. task that dumps one of the databases to a network drive 2x
day. But these are running throughout the week...looking over the logs I
really don't see a correlation...(ie. these same processes run on days
that no crash occurs and successfully later in the day that the crashes
do occur (some hours earlier).

-----Original Message-----
From: Gross, Cindy [mailto:CindyGross@hmhs.com]
Sent: Monday, October 25, 1999 2:14 PM
To: SQL 6.5 Discussions
Subject: RE: Weekly server hang



Did you check the SQL Server errorlog (sometimes things are written here
that don't go to the event viewer) and the NT event viewer (application
and
system)?

You could try turning on SQL Trace to see if you can capture a "bad"
query
but depending on how SQL goes down it may not be captured.

If you are auditing successful logons you could take a look to see if
there
is any pattern in who logs in just before SQL restarts.

Any chance someone is actually stopping it on purpose? Or maybe a
program
that is stopping it (maybe a backup system trying to backup the device
files
instead of the dumps)?

Cindy Gross
SQL Server MCP
Texas Health Resources
http://members.tripod.com/cindygross/sqlsrvr.htm

> -----Original Message-----
> From:Driggers, John [SMTP:John_Driggers@spspay.com]
> Sent:Monday, October 25, 1999 12:26 PM
> To: SQL 6.5 Discussions
> Subject: Weekly server hang
>
> List-Unsubscribe: <mailto:leave-mssql-13928C@ls.swynk.com>
> List-Software: Lyris Server version 3.0
> List-Subscribe: <mailto:subscribe-mssql@ls.swynk.com>
> List-Owner: <mailto:owner-mssql@ls.swynk.com>
> X-URL: <http://www.swynk.com/sysapps/sql.asp>
> X-List-Host: swynk.com discussion lists <http://www.swynk.com>
> Reply-To: "SQL 6.5 Discussions" <mssql@ls.swynk.com>
> X-Message-Id: <06F417B00B8CD1119BA400008322DF6D03515E78@spsgex01>
> Sender: bounce-mssql-14964@ls.swynk.com
> Precedence: bulk
>
> This one is bugging the tar out of me. Running SQL 6.5 sp5a, NT4 sp4
on
> the
> server. Either on the weekend or Mon. mornings (happened all 3 days
this
> past week) the SQL service stops on the server. This is during low
usage
> times. The box is a DELL 4300 dual 450 w 512 RAM (250 dedicated to
SQL).
> All
> other services on the server are ok, except for SQL.
>
> I'm thinking maybe a bad query hitting the server (I've seen this
happen
> before) but the programmers claim there is nothing special about these
> time
> periods that something "unique" would be happening. After I restart
the
> server it may not happen until the next week (this past weekend being
an
> exception). I thought maybe I had a memory leak but running perf.
monitor
> before a crash once revealed 99+% data cache, available proced. crash,
low
> CPU usage, low swapping....anything else I could check?
>
> Maybe reinstalling the sp5a? Any suggestions on things to try would be
> most
> appreciated...
>
> Thanks, John
>
>
> ------
> FAQ: http://www.swynk.com/faq/sql/sqlserverfaq.asp
> Please post SQL Server 7.0 questions to the SQL 7 list
> http://ls.swynk.com for list server signup/maint options
> You are subscribed as cindygross@hmhs.com
> Archives: http://www.swynk.com/sitesearch/search.asp
> To unsubscribe send a blank email to leave-mssql-13928C@ls.swynk.com

------
FAQ: http://www.swynk.com/faq/sql/sqlserverfaq.asp
Please post SQL Server 7.0 questions to the SQL 7 list
http://ls.swynk.com for list server signup/maint options
You are subscribed as John_Driggers@spspay.com
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe send a blank email to leave-mssql-13928C@ls.swynk.com

View 1 Replies View Related

Simplest Way To Crash A Sql Server

Jul 10, 2006

Hi,
What is the simplest way to crash a sql server?
Somebody asked me that question, and I was unable to give the best answer. Please help me to find it.
Thanks!!
Joydeep

View 14 Replies View Related

URGENT - SERVER CRASH

Jul 23, 2005

Hi All,Our SQL Server just crashed with the following messages:The Scheduler 5 appears to be hung. SPID 85, ECID 0, UMS Context 0x06C22478.Error: 17883, Severity: 1, State: 0We are running SP3 on cluster on a SAN.Any ideas?ThanksMichael

View 1 Replies View Related

Server SQL-Server 2005 Crash While Indexing By The Server SharePoint 2007

Feb 7, 2008

Hello,


I have an intranet environment consists of two servers:

- An application server windows 2003 server with 64-bit server Sharepoint 2007 SP1 (Standard version for search)
- A database server windows 2003 server with 64-bit SQL Server 2005 SP2 64-bit (Standard - 9.0.3054)


It happens regularly that the database server crash (frozen black screen) while the application server indexes (crawl) the content of the intranet site based on sharepoint. There is no alert / error in the observer of events, nor in the sql logs.


The crash is uncertain: dice once all goes well, soon after that crash. When i set the parameter search service (service management research), I can define a regulatory impact of the robot to change the number of documents at the same time : "Request 2 documents at the same time, the crash is more rare, "ask 64 documents at a time, the crash is more common.


My Intranet under sharepoint is composed of a collection site with a dozen sub-sites. There are 3 large library of PDF document. All done in the 4 go in terms of volume.


My problem for about 3-4 months. (Maybe more. Before, indexing was not yet in place).

Someone could help me? Thank you

View 2 Replies View Related

SQL Server Viewing A Table Causes PC To Crash

Jan 13, 2007

This is a new problem to me, I have been running SQL Server 2000 with VS 2003 and last summer upgraded to SQL Server 2005 with VS 2005 - (both evaluation copies)  all was fine
I bought the full upgrade of VS 2005 and SQL server dev edition in Dec 2006 and recently I have started to get a total system fallover dreadful noise followed by black screen and reboot.
This happens only when I view the Table Data "Show Table Data" in "Server Explorer" in VS2005, viewing design is OK, stored prcredures OK
I suspect this is either a hardware impending failure or software conflict but I would like some pointers please
I am using XP Pro sp2 with 1GB ram, F Secure Internet security, the Database is hosted externaly

View 5 Replies View Related

How Can I Restore My Data After Nt Server Crash?

Jan 22, 2001

NT server 4.0 crahsed. And there was no emergency repair disk. So, I copied all MS SQL server7.0 data files. After that i created new partition, formatted and installed Nt Server and SQL server 7.0. But how can i restore my old data? Please tell me what to do now?

View 1 Replies View Related

Sql Server 2000 Causing TCP/IP To Crash?

Nov 23, 2005

I installed Sql Server 2000 on a Windows 2003 machine and everythingappeared to be fine. It has Sql Server SP4 and Windows 2003 SP1 installed.The problem occurs whenever I use Enterprise Manager or Query Analyzer formore than a few minutes. After a while, all internet connectivity on theserver machine is broken. I cannot connect to it through Enterprise Manager,and on the machine itself, nothing related to the internet works at all.There are no errors in the Windows log or the Sql log. Disabling andenabling the Ethernet adapter fixes connectivity, until the next time I useEnterprise Manager for a while. What is going on?The machine is a Dell PowerEdge SC420 with a BroadCom NetXtreme Gigabitadapter and Windows 2003 Enterprise Edition.

View 2 Replies View Related

HELP - SQL Server Crash ? Memory Leak ?

Jul 20, 2005

Hi everybody !I´m maintaining a large intranet (approx 10000 concurrent users) running onone IIS box and one DB box with sqlserver 2000.Currently there is 2,5 GB Ram, 1 1400 mhz cpu and 2 scsi disks installed onthe db box.Sqlserver is set to use max 1,4 GB RAM, and the sqlserver does not seem tobe using it all.Currently SQLSERVER 2000 crashes at least once a day.Its very weird, I run performance monitor with counters on, memory, diskusage, num users, locks and such.There is no indications in the counters before the crashes, they just happenvery sudden.Only indication is that sqlserver makes some huge jumps in memory usage andmostly the sqlserver then crashes an hour or 2 later.The only thing that peaks a lot are the locks/sec counter.My analysis of disk usage, queues etc. tells me i got no kind of i/obottlenecks.Can anybody give me a clue as to what i should do ?Best regards, Thue

View 19 Replies View Related

Server Crash Help Follow Up URGENT HELP Needed

Nov 20, 2000

Follow up for previouse message

I had only 40 mb of disk space in the c drive. could that be the reason. if so, how can I turn on the server and get into win NT and make the server up and running.
I hope someone can reply as soon as possible

Ahmed

View 1 Replies View Related

Sql Server Project Visual Studio Crash

Dec 9, 2006

I'm having trouble with CLR based user-defined functions.

When I create a database C# project in Visual Studio 2005, the dialog to
pick the database connection doesn't apprear. Except for that, the project
seems to be created normally. I am able to write and build my project
without a problem.

When I try to release, it says that the connection isn't defined. I do a Project ==> <projname> and then select the database tab on the side. I am unable to type in a connection string because it's grayed out. When I hit the browse button. Visual Studio crashes.

I have one thrid-party Visual Studio installed, Sybase PowerDesigner. I also have the SQL Server 2000 and 2005 client tools installed.

I tried uninstalling the PowerDesigner module. I tried reinstalling and repairing the SQL Server client tools and Visual Studio 2005. I tried uninstalling SQL Server 2000 and 2005 client tools and then intalling Visual Studio 2005 fresh.

Nothing seemed to fix the problem.

Has anybody seen this before? Any ideas on how to fix this? I found a work around to install the dll from SQL Server, but I would really like to deploy from Visual Studio.

Any help is appreciated.

View 10 Replies View Related

Linked Server To Oracle Causes SQL Server Instance To Crash

Mar 3, 2007

When running a linked server to Oracle using the MSDAORA driver using in-process option checked, I'm getting the following error:



"A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)"

This then causes the instance to crash.



In the Event Log, it shows:

SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).



When using the out-of-process, it shows the column names in the query results window, but doesn't show any data then immediately in the message window it shows:





Msg 7399, Level 16, State 1, Line 2

The OLE DB provider "MSDAORA" for linked server "smtest" reported an error. Access denied.

Msg 7350, Level 16, State 2, Line 2

Cannot get the column information from OLE DB provider "MSDAORA" for linked server "smtest".



We're using:

SQL Server 2005 SP1 with hot fixes (9.0.2153) 32-bit on 64-bit o/s Windows 2003 R2 Standard x64 Edition Sevice Pack 1



We use lots of linked servers to Oracle on other servers, and can't find anything different on this one.



Appreciate any thoughts, insights!



thanks,

Steve

View 4 Replies View Related

SQL 2012 :: Memory Usage Extremely High And Causes Server To Crash

Jun 11, 2015

I have been having issues with our SQL server for awhile now. It seems to run out of memory every few days and when I look at the memory dump, the MEMORYCLERK_SQLOPTIMIZER seem to take over memory and eventually cause the server to crash.

Here is the SQL verison we are using: Microsoft SQL Server 2012 (SP1) - 11.0.3460.0 (X64) Jul 22 2014 15:22:00 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.2 (Build 9200: ) (Hypervisor)..It is on a VM on Windows 2012 server. It has 20gb of RAM allocated to it and the MAX Server Memory is set to 16.5gb.

I have seen the MEMORYCLERK_SQLOPTIMIZER grow to about 11gb at the time of the server crash. Why that is happening? What is causing the memoryclerk_sqloptimizer to get so high? I have looked it up and it looks like it has to do with ad hoc requests, but is there something I can do to bring that memory down when it gets so high so that I can prevent a server crash?Do we just need to add more memory or is there a memory leak somewhere?

View 2 Replies View Related

Server Optimization

Mar 5, 2008

Hi All,
Were I work we have a standalone system that writes information to an event log. Currently this event log is in .mdb (MS Access) format. The problem we have is that the .mdb seems to get very slow to access after 100,000 rows or so, so it needs to be cleared out regularly. We have long discussed using an SQL server to log the events to instead of an .mdb file.

I have written a VB program to test the two DB formats and i expected MS SQL server 2005 to be faster at reading/writing than the .mdb. Both the server and the .mdb are local to the system (it's a standalone system), so we know it's not network that is making the SQL server slower. So here is my question: does anyone know of any good tips/tricks in the server configuration options to speed it up/generally improve performance?

The table definitions are the same in both SQL server and the .mdb file:
Table:event_log_0000_000000
Module - Text
Event_date - Text
Event_Time - Text
Event - Text
Record_Number - int, primary key
I know it would probably be better to have Event_date and Event_Time as datetime types, but I’m not in charge of that decision. The data/table doesn't matter to much i just need to prove that the SQL server is better (and faster) than a .mdb file.

The VB program uses DAO to access the .mdb DB and ADODB to access the SQL server - this is the only difference to how the DB's are accessed and I don't think it would account for the slowness of the SQL server.

This is my first post here, so I’ve probably missed out some vital information, so please ask.

Also sorry if this is the wrong place to post this question, it sort of covers Access/SQL Server 2005/Database programming areas, so wasn't sure.

Thanks

View 14 Replies View Related

Where Can I Get Materials About Query Optimization In SQL Server?

Aug 16, 2006

It is said that, aimed at the same task, different SQL Select Statements maybe have different efficiency. Microsoft Corp. has provided the tool,Query Analyzer, but I have not any idea.

Thanks.

View 4 Replies View Related

A Update Data Optimization Job Freezed The Server

Jul 2, 2001

Hi, everyone,

I have a SQL2000(SP1)/Windows2000, and a database - 4GB. The server physical memory is 1GB, and about 900MB is allocated to the SQL2000 through the memory dynamical configuration screen.

A scheduled database maintenance job was created using the standard maintenance planner tool. In this job, only Updata Data Optimization was included. Everytime, this job freezed the whole server - all screens, SQL client accesses, and, even the keyboard. A server machine reboot had to be made.

My understanding about Optimizatoin is that it does reindex for each index of each table in the database. So I picked the largest table in the database - about 1.5 million rows - to run DBCC DBREINDEX manually against each index one at a time, using the Query Analyzer. They were all running through, without causing server lockup. However, I noticed that each time, the DBREINDEX statement made the CPU and Physical I/O climbed extreamlly high. I suspected that, since the Optimization job put all tables together to DBREINDEX, it might exhaused the system resource that caused the server problem, but I am not 100% sure, neither do I know where to confirm this.

Confusing enough, other databases on the same server didn't have the problem. They all have maintance plan and run ok. I did all sorts of DBCC checks against this database which I had problem with, they were no error reported. I even loaded the database, using the backup, to another SQL 2000 server, and run Optimization there, and it had no problem.

I am not sure it is a server issue? or a database issue? or a SQL bug? Anybody had same experience?

Appreicate!

Regards! Yan Li

View 1 Replies View Related

.NET Runtime Optimization Error On SQL Server 2005

Jan 7, 2006

I posted this on the .NET Framework inside Sql Server forum as well.  Sorry if the cross-post offends anybody.

I upgraded my primary production server this morning to SQL 2005.  Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:
 
Source: .NET Runtime Optimization Service
EventID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
 
I am a little stumped since we did not install Reporting Services.  We only installed Database Services, Integration Services and Workstation Components.  I'm open to any suggestions on this.  This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.
 
Thanks,
Kevin

 

View 47 Replies View Related

SQL Server Admin 2014 :: Quorum In AlwaysOn And Enabling Memory Optimization?

Nov 26, 2014

We are planning to 2014 migration in few days.

ServerA----- ServerA1

ServerB---- ServerB1

In serverA we have 5databases. And making 5databases as availability group. The replica is ServerA1

In server B we have 3 databases. And the making those 3 databases as an availibility group. The secondary replica is ServerB1.

What is the best option to configure the quoram drive in this situation.

Also Server A1 & Server B1 also we use for reporting purposes.

We have some sensitive data. Is it possible to delete the data while reading the data?

How the memory optimization feature work with always on?

View 8 Replies View Related

Crash...

Feb 19, 2004

Hi my name is Rodrigo and Im from Brasil, so, sorry about my english.

I have a problem using MSSQL 2000. I´m using a client/server application, and sometimes (almost every day) the sql server start to use 100% of CPU and crash the system. I don´t know how and when but it hapens always. I never found a reason for it, but looking at the event viewer in windows 2000 i saw an error about www publishing (something like that). Maybe my sqlserver is trying to connect to internet to do something (i don´t know). Please if somebody can help me send me a mail. Thanks a lot.

View 6 Replies View Related

Installation Crash

Sep 21, 2006

Hi, I'm trying to install SQL Server 2000 Dev Edn. When I install client and server tools it will crash after I enter the administration password. But this only happens when I install it with server tools, its OK with just client tools. Thanks 

View 8 Replies View Related

Database Crash In 7.0

Jul 7, 2000

Hi Everybody,

What type of 'Database Crash' can we expect in SQL Server 7.0.? and How do we rectify this ?.


Thanks in Advance.
Srinivasan

View 1 Replies View Related

On-going SQL 6.5 Crash.....17805

Mar 21, 2000

hello:

Does anyone have any input on why my SQL Server keeps crashing? I get the following errors:
Error : 17805, Severity: 18, State: 0
00/03/21 09:06:06.42 ods Invalid buffer received from client.
00/03/21 09:09:51.56 kernel SQL Server terminating due to 'stop' request from Service Control Manager
At other times, there were some STACK DUMP ERRORS.
We are on service pack 4 (I have been pushing to apply 5a)
Please help,
Thank you.

View 1 Replies View Related

Getting Db Files After Crash

Dec 3, 2004

Hi.
I need urgent help :o/

My laptop crashed and I am not able to start any programs but I can reach the files.

How can I get a hold on by database tables???

Please help me.

BEST REGARDS

Badleif

View 2 Replies View Related

Database Crash

Aug 1, 2006

Hi All,

What are the steps of recovering SQL Server 2000 database after it crashes?
Is it documented somewhere?

View 13 Replies View Related

Crash Database

Oct 12, 2006

My database is marked suspect/offline in the enterprise manager. i am
using
sql server 2000.i have tried resetstatus,DBCC CheckDB, alter
database,sp_dboption and DBCC ALLOCDB ( 'dbname' ) but all to no
avail.i
have no backup of the database.
And i really need to get back this data.Please, can you give me a
detail
step by step method of how to overcome this problem.
i greatly anticipate your reply!!!
Thanks

View 1 Replies View Related

Recovery From Crash

Jul 20, 2005

Greetings,I had a hard-drive failure this week and lost my root drive, withoperating system and SQL Server 2000.Fortunately my data was on another volume and still exists.I know about sp_attach_db, but looking at BOL, it says that sp_attach_dbonly works with databases that were previously detached withsp_detach_db.How do I reattach my existing mdf and ldf files?-- RickP.S. I know that the dbs are not corrupt because when the hard drivefailed SQL Server was offline.

View 2 Replies View Related







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