Re: BizTalk eating up SQL Server (Virii Behaviour)

Hi,

What is the volume of orchestrations you are trying to run? Both SQL
and Biztalk on the Same Box? and with 1 GB of RAM? are you processing
any flat files? where are you picking up documents to be processed?

Are the orchestrations trying to write data into DB through an adaptor.
If Yes, what is the size of the table(Number of records) and are tehre
any indexes to help this process?

Thanks,
Sandeep Kesiraju
rene.rugerio@xxxxxxxxx wrote:
Thanks for your replies, Leo

The orchestrations (and everything related to them) are stopped on
purpose, since it my development environment i decided to do that to
see why its cosuming resources as hell.

I think my best bet was to reconfigure, but i decided to go the
uninstall procedure, i manually deleted all databases, and run the
installation process again. It was fine for a while but then it follow
the same behaviour but this time I got sick of this and decided to
"give it space". The process suddenly stops to process at 100%, but now
another problem was shown. BTSNTSvc was like 700+ of the virtual memory
and it was leaving like 20 mbs free memory, lol.

So it was unusable again ... Im really mad. I think i will repair it
now, got nothing to loose after all. I will post further notices if
this corrects this issues (for me, theyre issues).


Leo Gan wrote:
What about SSODB?
BTW Why the Orch are unlisted? For purpose or they "trying"?
If it is a dev comp why just don't reconfigure BTS (and recreate DBs)?


--
Regards

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

<rene.rugerio@xxxxxxxxx> wrote in message
news:1158090995.486282.232530@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

This is the sad part, the jobs were executed as well. As a matter of
fact, I executed the stored procedures to clean up the databases
(msgbox and dta). So, I do not know where the problems began if the
msgbox-dta is apparently "empty", it holds like 250 megabytes (data and
log), but the queries for the sql when the bts service is running are
extensive and way resource consuming.

:'(

Is there any way that i can restore the original databases just like
after installation ?

Leo Gan ha escrito:

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 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)
  • Re: Running two instances of BizTalk generated code?
    ... compoinent names or changes to orchestrations, I MUST find a way to support ... This WAS is configured to talk to a queue manager running on UNIX. ... our INT and QT WAS applications are currently being fed by a single BizTalk ...
    (microsoft.public.biztalk.general)