Re: BizTalk eating up SQL Server (Virii Behaviour)

Yes ! Sorry i did not mention that. My event logs are clean.
app log shows that the bts service started and nothing else. And the
other event logs are clean as well, no weird information. :\ (security
audits okey, and other stuff seems okey)

Officially, I do not what other actions to take.

Just for the record
BTSNTSvc.exe - 440,976k - 00~02% CPU
sqlservr.exe - 166,376k - 95~99%

Thanks in advance !


Leo Gan wrote:
What is in the Event logs??? (All of them)

--
Regards

Leonid Ganeline
BizTalk Solution Developer
===========================
http://geekswithblogs.com/leonidganeline
================================

<rene.rugerio@xxxxxxxxx> wrote in message
news:1158077822.227199.204060@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Dear forum
Im having this trouble in my development environment, where i have
biztalk server 2006, sql server 2005 and vs.net 2005. Everything was
fine, eventhough sql depletes all my available ram memory, it ran just
enough. I have just one gig of ram, i know is to the min, but this is
just a small dev environment.

Suddenly, my biztalk service (btsntsvc) when running, it is acquiring
so much space in memory, but the trouble comes when it pushes the sql
service to dangerous levels. It starts doing a lot of queries, i traced
them on the profiler, they seem alike, running stored procedures as
hell and my dual core is suffering in a 98% - 100%. No need to say the
system is unstable and unusable.

You may say that is a consecuence, but this are my facts. It was
running fine, i mean they both are memory hogs, i can deal with that,
but i cant deal with a 1% of processor activity. The sql highest rate
of processing is only due to biztalk.

Everything points to the database corruption, because my orchestrations
are not completing anymore, they are just hanging in the breeze, but no
completion is made. They are kept active. What i have tried is to
delete all messagebox and all dta information. No success after all. I
also tried by enforcing the jobs running. No success. I reinstalled.
Now I am desperate.

As a matter of fact, they are no orchestrations running. Just one is
deployed but it is unenlisted !!! NONE !!!

This is not just annoying, this is lethal. The hardware seems to be
enough. But those services are killing my dev machine.

Well, if someone had an experience on these, maybe restoring databases
from the scratch, help meeee.


.

Relevant Pages

  • RE: biztalk security
    ... Both BizTalks need WMI, IIS, Event Logs, COM+, and network access which ... IIS & WWW services in order to use Messaging Manager and for the document ... Microsoft Biztalk Server Team ...
    (microsoft.public.biztalk.server)
  • Re: VBSCRIPT with SQL help
    ... > promise by years end I will learn SQL. ... >> | modified to capture event logs, I now want to modify it again to ... >> | Below is my current script if you can lend a hand that would be great ... >> | What I have doen so far I Import the Access data that use to hold the ...
    (microsoft.public.scripting.vbscript)
  • Re: Cant connect to SQL server after hibernating
    ... Yes...the Event viewer displays the event logs. ... necessarily just SQL errors related to connection failure. ... >>>I currently have a development SQL server running locally on my laptop. ...
    (microsoft.public.sqlserver.connect)
  • Windows Event Log Storage
    ... Does anybody have any advice on how I could store Windows event logs in SQL ... I know I can save the .evt files as a .csv and import them. ... language with SQL Server. ...
    (microsoft.public.sqlserver.security)
  • Re: Sharepoint not working anymore
    ... For the sqlagent$sbsmonitoring check in the \program files\microsoft sql ... Microsoft Small Business Server Support ... > System was having problems with Event ID 2000 srv flooding the event logs, ... but the only thing that was truely suggested was to install SBS ...
    (microsoft.public.windows.server.sbs)
Loading