Re: BizTalk eating up SQL Server (Virii Behaviour)

Are your BizTalk job OK (status?)?
Try to figure out the size of your BTS Databases. Are your Log files OK
(Backups?)?

--
Regards

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

<rene.rugerio@xxxxxxxxx> wrote in message
news:1158081245.189244.3840@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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 eating up SQL Server (Virii Behaviour)
    ... Both SQL ... Are the orchestrations trying to write data into DB through an adaptor. ... uninstall procedure, i manually deleted all databases, and run the ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: BizTalk Server 2004 ConfigFramework.exe error
    ... one BizTalk is installed on? ... machines (both for SQL and DTC) is not blocked by firewalls and new MSDTC ... Multi-computer configuration using Windows Server 2003 or Windows XP ... >>all associated databases. ...
    (microsoft.public.biztalk.general)
  • RE: Biztalk 2004 Running Against SQL 2005
    ... BizTalk Server 2004 databases cannot be hosted in SQL Server 2005, ...
    (microsoft.public.biztalk.general)
  • RE: Deployment Recommendations
    ... Yes BizTalk can be setup to run on a single machine with SQL ... The reason for this is because the databases are fairly resource intensive. ... Would it be feasible to install the Biztalk components and corresponding ...
    (microsoft.public.biztalk.server)
  • Re: New to Biztalk! Please help.
    ... I will be back with more info once i do some r&d on Biztalk ... > You can integrate directly the databases, sql and fox, but the ... with Biztalk 2004 you have the sql adaptader to talk with the ... >> Devesh Aggarwal ...
    (microsoft.public.biztalk.general)