Re: BizTalk eating up SQL Server (Virii Behaviour)

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 eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ... sql server 2005 and vs.net 2005. ...
    (microsoft.public.biztalk.general)
  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... (msgbox and dta). ... Is there any way that i can restore the original databases just like ... BizTalk Solution Developer ... sql server 2005 and vs.net 2005. ...
    (microsoft.public.biztalk.general)
  • RE: BTS 2004 not connecting to SQL2005
    ... BizTalk Server 2004 databases cannot be hosted in SQL Server 2005, ... BTS 2004 not connecting to SQL2005 ... We're running BTS2004 with all its databases on SQL 2000. ...
    (microsoft.public.biztalk.general)
  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Are your BizTalk job OK? ... Try to figure out the size of your BTS Databases. ... BizTalk Solution Developer ... sql server 2005 and vs.net 2005. ...
    (microsoft.public.biztalk.general)