SQL SQLExpress: production

Showing posts with label production. Show all posts

Sunday, March 25, 2012

@@CPU_BUSY stops incrementing and generates "Arithmetic overflow occurred"

I am using several globals including @.@.CPU_BUSY to log the performance of some stored procedures. It works fine on my dev server, but in production the value reported by @.@.CPU_BUSY on my production server has stopped at 134217727. And when I try to assign its value to a variable, it always generates an error.

For example:

DECLARE @.FOO BigInt
Set @.foo = @.@.CPU_BUSY
print @.Foo

generates

Arithmetic overflow occurred.
134217727

Note that

DECLARE @.FOO BigInt
Set @.foo = 134217727
print @.Foo

works fine.

I understand that when the value of @.@.CPU_BUSY reaches a certain point, its value becomes inaccurate according to MSDN TSQL Reference. I've also seen some descriptions that say the value is supposed to "wrap" back to zero.

So the questions are:
Is the value of @.@.CPU_BUSY supposed to wrap back to zero when it overflows?
Is there a better/more reliable way to do this?

Cheers,
Jeff
by the way:
Select @.@.version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)sql

Thursday, March 22, 2012

CAn anyone give me tips about what to analyse on a databse
that is in developmente before entering production.. i
already used both microsoft tools BPS and MSBA... anything
else?
> CAn anyone give me tips about what to analyse on a databse
> that is in developmente before entering production.. i
> already used both microsoft tools BPS and MSBA... anything
> else?
>
You should also use SQLIOStress tool to ensure that your hardware can cope
with typical load from SQL Server.
Checkout this article:
HOW TO: Use the SQLIOStress Utility to Stress a Disk Subsystem Such As SQL
Server
http://support.microsoft.com/?id=231619
Hope this helps,
Eric Crdenas
SQL Server senior support professional

CAn anyone give me tips about what to analyse on a databse
that is in developmente before entering production.. i
already used both microsoft tools BPS and MSBA... anything
else?> CAn anyone give me tips about what to analyse on a databse
> that is in developmente before entering production.. i
> already used both microsoft tools BPS and MSBA... anything
> else?
>
--
You should also use SQLIOStress tool to ensure that your hardware can cope
with typical load from SQL Server.
Checkout this article:
HOW TO: Use the SQLIOStress Utility to Stress a Disk Subsystem Such As SQL
Server
http://support.microsoft.com/?id=231619
Hope this helps,
Eric Crdenas
SQL Server senior support professional

Tuesday, March 20, 2012

CAn anyone give me tips about what to analyse on a databse
that is in developmente before entering production.. i
already used both microsoft tools BPS and MSBA... anything
else?> CAn anyone give me tips about what to analyse on a databse
> that is in developmente before entering production.. i
> already used both microsoft tools BPS and MSBA... anything
> else?
>
--
You should also use SQLIOStress tool to ensure that your hardware can cope
with typical load from SQL Server.
Checkout this article:
HOW TO: Use the SQLIOStress Utility to Stress a Disk Subsystem Such As SQL
Server
http://support.microsoft.com/?id=231619
Hope this helps,
--
Eric Cárdenas
SQL Server senior support professional

Sunday, March 11, 2012

.NET Runtime Optimization error on SQL Server 2005

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

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.

Thanks

Steve

|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.

After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

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

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

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

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

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

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

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

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

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

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

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

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

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

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

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

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

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

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

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

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

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

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

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

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

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

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime error on SQL Server 2005 (RTM)

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

Same error in event logs on 2 different servers that SQL 2005 (RTM) was installed upon.

It's from the .NET Runtime Optimization process.

Suggestion includes uninstalling SQL 2005, .NET and repairing the Visual Studio installation (performed by SQL) and re-installing. However, this issue is intrinsic to the setup process performed by Microsoft's .NET and SQL software. It will only happen again.

Still looking for a clean-cut answer to the origin of this and if a solution needs to be implemented. Since this was a one-time attempt at compiling the Microsoft.ReportingServices.QueryDesigners DLL (where Reporting Services wasn't evoked in the SQL 2005 setup) and based on what I've read on other forums, it's currently nothing to worry about.

Still, I'd like an answer too.

|||Thanks for the reply. I had seen that suggestion in another forum to uninstall/repair/reinstall, but that is not really an option on this particular server. That would be a major risk to our production environment. Not to mention, it is sort of like cutting off a hand to remove a splinter from a finger.|||I have the same thing on a dev machine and reinstalling didn't help. Eventually even reinstalled the OS (W2K3) and got the same results.|||

I'm installing W2003 Sp1 server from the scratch (intended for TFS beta3 refresh ATDT) with order:

1. W2003 Sp1 server (application server in Workgroup)

2. Updates

3. IIS...(ASP.NET, no FrontPage Extensions )

4. SQL server...full install

5. stsv2.exe (Share Point services 2.0, Sp2)

At this point I looked at Event log and found the error.

|||I installed from scratch windows 2003 R2 and SQL Server 2005 and I get this error.|||I recently had the same problem. I was able to fix this by uninstalling .net 2.0 and rebooting the server. Then I reapplied the .net 2.0 and rebooted the server again and the message went away.

Sunday, March 25, 2012

@@CPU_BUSY stops incrementing and generates "Arithmetic overflow occurred"

Thursday, March 22, 2012

Tuesday, March 20, 2012

Sunday, March 11, 2012

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime error on SQL Server 2005 (RTM)

SQL SQLExpress

Blog Archive

About Me