I have a sequence of 3 operations, and its repeated many times by an
aplication (timer loop)
1) Open a transaction
2) Execute 1 (ONE) insert in a "simple" table. This table has only an
auto-increment identificator and some fields numbers and chars.
3) Comitt the transaction
This proccess is executed normaly during many days, but many times this
command returns "0 rows affected" to the application, but with no exception,
just returns "0 rows affected".
The version is 2000 with all SP.
Thanks
RaphaelPlease post insert statement and create table. Does this table have a
trigger (instead off or something like that)? How do you insert? Through
stored procedure or not?
MC
"Raphael Rodrigues" <rrodrigues@.cmsolucoes.com.br> wrote in message
news:uD$ygZq7FHA.736@.TK2MSFTNGP09.phx.gbl...
>I have a sequence of 3 operations, and its repeated many times by an
>aplication (timer loop)
> 1) Open a transaction
> 2) Execute 1 (ONE) insert in a "simple" table. This table has only an
> auto-increment identificator and some fields numbers and chars.
> 3) Comitt the transaction
> This proccess is executed normaly during many days, but many times this
> command returns "0 rows affected" to the application, but with no
> exception, just returns "0 rows affected".
> The version is 2000 with all SP.
> Thanks
> Raphael
>
>|||1) Create TABLE COMMAND
CREATE TABLE [cm].[BILHETE] (
[IDBILHETE] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[BILHETE] [varchar] (500) COLLATE Latin1_General_CI_AS NULL ,
[IDHOTEL] [numeric](18, 0) NULL ,
[DATACAPTURA] [datetime] NULL ) ON [PRIMARY]
2) Insert COMMAND executed by the application. Only an example, the error is
intermittent and random.
INSERT INTO BILHETE (BILHETE, IDHOTEL, DATACAPTURA) VALUES
('1450290000001010022161313', 1, getDate());
3) I've already tried with a Stored Procedure, but accurs the same problem.
After many times the SP returns "0 (zero) rows affected". Do not insert
nothing and no exceptions are generated.
CREATE PROCEDURE CM.SP_BILHETE(@.Bilhete AS Varchar(220),@.IdHotel AS
Numeric ) AS
INSERT INTO BILHETE (BILHETE,IDHOTEL,DATACAPTURA) VALUES
(@.Bilhete,@.IdHotel,getdate());
3) The table has the follow DELETE TRIGGER, that saves the deleteds records
in another table _BILHETE with the same structure:
CREATE TRIGGER tdBilhete
ON BILHETE
FOR DELETE AS
DECLARE @.STRBILHETE VARCHAR(120)
DECLARE @.IDHOTEL NUMERIC
SELECT @.STRBILHETE = D.BILHETE FROM DELETED D
SELECT @.IDHOTEL = D.IDHOTEL FROM DELETED D
INSERT INTO _BILHETE (BILHETE,IDHOTEL,DATACAPTURA) VALUES
(@.STRBILHETE,@.IDHOTEL,getdate());
"MC" <marko_culo#@.#yahoo#.#com#> escreveu na mensagem
news:OuB80cq7FHA.444@.TK2MSFTNGP11.phx.gbl...
> Please post insert statement and create table. Does this table have a
> trigger (instead off or something like that)? How do you insert? Through
> stored procedure or not?
> MC
>
> "Raphael Rodrigues" <rrodrigues@.cmsolucoes.com.br> wrote in message
> news:uD$ygZq7FHA.736@.TK2MSFTNGP09.phx.gbl...
>>I have a sequence of 3 operations, and its repeated many times by an
>>aplication (timer loop)
>> 1) Open a transaction
>> 2) Execute 1 (ONE) insert in a "simple" table. This table has only an
>> auto-increment identificator and some fields numbers and chars.
>> 3) Comitt the transaction
>> This proccess is executed normaly during many days, but many times this
>> command returns "0 rows affected" to the application, but with no
>> exception, just returns "0 rows affected".
>> The version is 2000 with all SP.
>> Thanks
>> Raphael
>>
>
Showing posts with label transaction. Show all posts
Showing posts with label transaction. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
Intermitent problem : New transaction cannot enlist in the specified transaction coordinat
I have a Windows 2003 Application Server. When I dont use the
Application for about 15 minutes, I get the error : "New transaction
cannot enlist in the specified transaction coordinator" when trying to
do a transaction with the Database server.
When I got the error, if I keep trying to do a transaction, eventually
the transaction process restart to work until I keep it inactive for
about 15 minutes.
I did some test with the application and with DTCTester. When it dont
work with the application it dont work with DTCTester
(http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
- The application server is Windows 2003 SP1
- This server connect to a Cluster SQL Server 2000 database intalled on
Windows 2003 servers .
- The two servers are in two differents Network zone.
- All ports are opened between Database servers and application
servers.
- MSDTC is started on the Application and Database server.
- In security configuration of MSDTC of the Application server the
option "No Authentication Required is selected". This option is not
selected on the Database server because the service pack 1 is not
installed.
- Database computers names are in the host file of the application
server and application server name is in the host file of the SQL
Server.
I did some test with another Database server (SQL Server 2000 on
windows 2000) and it always works, but these two server are in the same
zone.
I would like to know if someone have an idea why the transaction stop
to works after about 15 minutes and restart to work if I keep trying.
Thank you very much.
DavidHi Dave
I am not sure what you mean by different zones? Is this a different sub-net?
It is not clear if you are seeing exactly the same symptoms with DTC tester
or if it never works?
As the problem is intermittent it sounds like a network type issue rather
than the components. You may want to try changing network cards and
hubs/switches to see if it continues to fail. Also if there are any firewalls
make sure they are configured correctly, also make sure that no antivirus or
intrusion detection software is causing a conflict.
John
"Dave960" wrote:
> I have a Windows 2003 Application Server. When I dont use the
> Application for about 15 minutes, I get the error : "New transaction
> cannot enlist in the specified transaction coordinator" when trying to
> do a transaction with the Database server.
> When I got the error, if I keep trying to do a transaction, eventually
> the transaction process restart to work until I keep it inactive for
> about 15 minutes.
> I did some test with the application and with DTCTester. When it dont
> work with the application it dont work with DTCTester
> (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> - The application server is Windows 2003 SP1
> - This server connect to a Cluster SQL Server 2000 database intalled on
> Windows 2003 servers .
> - The two servers are in two differents Network zone.
> - All ports are opened between Database servers and application
> servers.
> - MSDTC is started on the Application and Database server.
> - In security configuration of MSDTC of the Application server the
> option "No Authentication Required is selected". This option is not
> selected on the Database server because the service pack 1 is not
> installed.
> - Database computers names are in the host file of the application
> server and application server name is in the host file of the SQL
> Server.
>
> I did some test with another Database server (SQL Server 2000 on
> windows 2000) and it always works, but these two server are in the same
> zone.
> I would like to know if someone have an idea why the transaction stop
> to works after about 15 minutes and restart to work if I keep trying.
> Thank you very much.
> David
>|||Hi John,
Thank's for your reply :)
- By different zone I mean different sub-net.
- I'm seeing exactly the same problem with dtctester. After a couple of
try it work's and if I do nothing for about 15 minutes it stop to work
until I try dtctester for a couple of try ( 2 to 20).
If I run a transaction between the application server and the SQL
server every 5-10 minutes, transaction always work.
The transaction process always work with another Database server
(Server2) in the same zone as my application server, so I think it's
not hardware related. But there is difference with this second server,
it run on windows 2000 and is not in a cluster.
If I do the dtctester test with the Database server (Server1 - the one
that I have problem with) with another application server in the Dabase
server sub-net it always works.
Another thing, I'm always able to retrieve data from the Database
server, I just have problem with transactions.
>From what I see it look like a network problem, but I dont see why
after about 15 minutes of inactivity it strop to work ?
If you have any ideas, let me know.
Thanks a lot.
David
It look similar to this problem :
http://groups.google.ca/group/microsoft.public.platformsdk.complus_mts/browse_thread/thread/da9b915896c6d8a1/66b4518597052cfb?lnk=st&q=&rnum=1&hl=en#66b4518597052cfb
John Bell wrote:
> Hi Dave
> I am not sure what you mean by different zones? Is this a different sub-net?
> It is not clear if you are seeing exactly the same symptoms with DTC tester
> or if it never works?
> As the problem is intermittent it sounds like a network type issue rather
> than the components. You may want to try changing network cards and
> hubs/switches to see if it continues to fail. Also if there are any firewalls
> make sure they are configured correctly, also make sure that no antivirus or
> intrusion detection software is causing a conflict.
> John
>
> "Dave960" wrote:
> > I have a Windows 2003 Application Server. When I dont use the
> > Application for about 15 minutes, I get the error : "New transaction
> > cannot enlist in the specified transaction coordinator" when trying to
> > do a transaction with the Database server.
> >
> > When I got the error, if I keep trying to do a transaction, eventually
> > the transaction process restart to work until I keep it inactive for
> > about 15 minutes.
> >
> > I did some test with the application and with DTCTester. When it dont
> > work with the application it dont work with DTCTester
> > (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> >
> > - The application server is Windows 2003 SP1
> >
> > - This server connect to a Cluster SQL Server 2000 database intalled on
> > Windows 2003 servers .
> >
> > - The two servers are in two differents Network zone.
> >
> > - All ports are opened between Database servers and application
> > servers.
> >
> > - MSDTC is started on the Application and Database server.
> >
> > - In security configuration of MSDTC of the Application server the
> > option "No Authentication Required is selected". This option is not
> > selected on the Database server because the service pack 1 is not
> > installed.
> >
> > - Database computers names are in the host file of the application
> > server and application server name is in the host file of the SQL
> > Server.
> >
> >
> >
> > I did some test with another Database server (SQL Server 2000 on
> > windows 2000) and it always works, but these two server are in the same
> > zone.
> >
> > I would like to know if someone have an idea why the transaction stop
> > to works after about 15 minutes and restart to work if I keep trying.
> >
> > Thank you very much.
> >
> > David
> >
> >|||Hi Dave
It is not clear why you need a distributed transaction, from what you say it
is only
the one server being used at any one time?
John
"Dave960" wrote:
> Hi John,
> Thank's for your reply :)
> - By different zone I mean different sub-net.
> - I'm seeing exactly the same problem with dtctester. After a couple of
> try it work's and if I do nothing for about 15 minutes it stop to work
> until I try dtctester for a couple of try ( 2 to 20).
> If I run a transaction between the application server and the SQL
> server every 5-10 minutes, transaction always work.
> The transaction process always work with another Database server
> (Server2) in the same zone as my application server, so I think it's
> not hardware related. But there is difference with this second server,
> it run on windows 2000 and is not in a cluster.
> If I do the dtctester test with the Database server (Server1 - the one
> that I have problem with) with another application server in the Dabase
> server sub-net it always works.
> Another thing, I'm always able to retrieve data from the Database
> server, I just have problem with transactions.
> >From what I see it look like a network problem, but I dont see why
> after about 15 minutes of inactivity it strop to work ?
> If you have any ideas, let me know.
> Thanks a lot.
> David
>
> It look similar to this problem :
> http://groups.google.ca/group/microsoft.public.platformsdk.complus_mts/browse_thread/thread/da9b915896c6d8a1/66b4518597052cfb?lnk=st&q=&rnum=1&hl=en#66b4518597052cfb
> John Bell wrote:
> > Hi Dave
> >
> > I am not sure what you mean by different zones? Is this a different sub-net?
> > It is not clear if you are seeing exactly the same symptoms with DTC tester
> > or if it never works?
> >
> > As the problem is intermittent it sounds like a network type issue rather
> > than the components. You may want to try changing network cards and
> > hubs/switches to see if it continues to fail. Also if there are any firewalls
> > make sure they are configured correctly, also make sure that no antivirus or
> > intrusion detection software is causing a conflict.
> >
> > John
> >
> >
> > "Dave960" wrote:
> >
> > > I have a Windows 2003 Application Server. When I dont use the
> > > Application for about 15 minutes, I get the error : "New transaction
> > > cannot enlist in the specified transaction coordinator" when trying to
> > > do a transaction with the Database server.
> > >
> > > When I got the error, if I keep trying to do a transaction, eventually
> > > the transaction process restart to work until I keep it inactive for
> > > about 15 minutes.
> > >
> > > I did some test with the application and with DTCTester. When it dont
> > > work with the application it dont work with DTCTester
> > > (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> > >
> > > - The application server is Windows 2003 SP1
> > >
> > > - This server connect to a Cluster SQL Server 2000 database intalled on
> > > Windows 2003 servers .
> > >
> > > - The two servers are in two differents Network zone.
> > >
> > > - All ports are opened between Database servers and application
> > > servers.
> > >
> > > - MSDTC is started on the Application and Database server.
> > >
> > > - In security configuration of MSDTC of the Application server the
> > > option "No Authentication Required is selected". This option is not
> > > selected on the Database server because the service pack 1 is not
> > > installed.
> > >
> > > - Database computers names are in the host file of the application
> > > server and application server name is in the host file of the SQL
> > > Server.
> > >
> > >
> > >
> > > I did some test with another Database server (SQL Server 2000 on
> > > windows 2000) and it always works, but these two server are in the same
> > > zone.
> > >
> > > I would like to know if someone have an idea why the transaction stop
> > > to works after about 15 minutes and restart to work if I keep trying.
> > >
> > > Thank you very much.
> > >
> > > David
> > >
> > >
>|||Hi John,
The application server run COM+ components that use distributed
transaction for certain type of query to the database.
This application is already running on another server, we just want to
switch this application to a new server that is in a different sub-net.
If there's missing informations, dont hesitate to ask me.
Thanks !!!
David
John Bell wrote:
> Hi Dave
> It is not clear why you need a distributed transaction, from what you say it
> is only
> the one server being used at any one time?
> John
>
> "Dave960" wrote:
> > Hi John,
> >
> > Thank's for your reply :)
> >
> > - By different zone I mean different sub-net.
> > - I'm seeing exactly the same problem with dtctester. After a couple of
> > try it work's and if I do nothing for about 15 minutes it stop to work
> > until I try dtctester for a couple of try ( 2 to 20).
> >
> > If I run a transaction between the application server and the SQL
> > server every 5-10 minutes, transaction always work.
> >
> > The transaction process always work with another Database server
> > (Server2) in the same zone as my application server, so I think it's
> > not hardware related. But there is difference with this second server,
> > it run on windows 2000 and is not in a cluster.
> >
> > If I do the dtctester test with the Database server (Server1 - the one
> > that I have problem with) with another application server in the Dabase
> > server sub-net it always works.
> >
> > Another thing, I'm always able to retrieve data from the Database
> > server, I just have problem with transactions.
> >
> > >From what I see it look like a network problem, but I dont see why
> > after about 15 minutes of inactivity it strop to work ?
> >
> > If you have any ideas, let me know.
> >
> > Thanks a lot.
> >
> > David
> >
> >
> > It look similar to this problem :
> > http://groups.google.ca/group/microsoft.public.platformsdk.complus_mts/browse_thread/thread/da9b915896c6d8a1/66b4518597052cfb?lnk=st&q=&rnum=1&hl=en#66b4518597052cfb
> >
> > John Bell wrote:
> > > Hi Dave
> > >
> > > I am not sure what you mean by different zones? Is this a different sub-net?
> > > It is not clear if you are seeing exactly the same symptoms with DTC tester
> > > or if it never works?
> > >
> > > As the problem is intermittent it sounds like a network type issue rather
> > > than the components. You may want to try changing network cards and
> > > hubs/switches to see if it continues to fail. Also if there are any firewalls
> > > make sure they are configured correctly, also make sure that no antivirus or
> > > intrusion detection software is causing a conflict.
> > >
> > > John
> > >
> > >
> > > "Dave960" wrote:
> > >
> > > > I have a Windows 2003 Application Server. When I dont use the
> > > > Application for about 15 minutes, I get the error : "New transaction
> > > > cannot enlist in the specified transaction coordinator" when trying to
> > > > do a transaction with the Database server.
> > > >
> > > > When I got the error, if I keep trying to do a transaction, eventually
> > > > the transaction process restart to work until I keep it inactive for
> > > > about 15 minutes.
> > > >
> > > > I did some test with the application and with DTCTester. When it dont
> > > > work with the application it dont work with DTCTester
> > > > (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> > > >
> > > > - The application server is Windows 2003 SP1
> > > >
> > > > - This server connect to a Cluster SQL Server 2000 database intalled on
> > > > Windows 2003 servers .
> > > >
> > > > - The two servers are in two differents Network zone.
> > > >
> > > > - All ports are opened between Database servers and application
> > > > servers.
> > > >
> > > > - MSDTC is started on the Application and Database server.
> > > >
> > > > - In security configuration of MSDTC of the Application server the
> > > > option "No Authentication Required is selected". This option is not
> > > > selected on the Database server because the service pack 1 is not
> > > > installed.
> > > >
> > > > - Database computers names are in the host file of the application
> > > > server and application server name is in the host file of the SQL
> > > > Server.
> > > >
> > > >
> > > >
> > > > I did some test with another Database server (SQL Server 2000 on
> > > > windows 2000) and it always works, but these two server are in the same
> > > > zone.
> > > >
> > > > I would like to know if someone have an idea why the transaction stop
> > > > to works after about 15 minutes and restart to work if I keep trying.
> > > >
> > > > Thank you very much.
> > > >
> > > > David
> > > >
> > > >
> >
> >|||Hi Dave
As this is intermitten, it implies that it is set up correctly and something
other than SQL Server is causing this to fail. Have you checked for intrusion
detection or virus checkers being active at this time?
John
"Dave960" wrote:
> Hi John,
> The application server run COM+ components that use distributed
> transaction for certain type of query to the database.
> This application is already running on another server, we just want to
> switch this application to a new server that is in a different sub-net.
> If there's missing informations, dont hesitate to ask me.
> Thanks !!!
> David
>
> John Bell wrote:
> > Hi Dave
> >
> > It is not clear why you need a distributed transaction, from what you say it
> > is only
> > the one server being used at any one time?
> >
> > John
> >
> >
> >
> > "Dave960" wrote:
> >
> > > Hi John,
> > >
> > > Thank's for your reply :)
> > >
> > > - By different zone I mean different sub-net.
> > > - I'm seeing exactly the same problem with dtctester. After a couple of
> > > try it work's and if I do nothing for about 15 minutes it stop to work
> > > until I try dtctester for a couple of try ( 2 to 20).
> > >
> > > If I run a transaction between the application server and the SQL
> > > server every 5-10 minutes, transaction always work.
> > >
> > > The transaction process always work with another Database server
> > > (Server2) in the same zone as my application server, so I think it's
> > > not hardware related. But there is difference with this second server,
> > > it run on windows 2000 and is not in a cluster.
> > >
> > > If I do the dtctester test with the Database server (Server1 - the one
> > > that I have problem with) with another application server in the Dabase
> > > server sub-net it always works.
> > >
> > > Another thing, I'm always able to retrieve data from the Database
> > > server, I just have problem with transactions.
> > >
> > > >From what I see it look like a network problem, but I dont see why
> > > after about 15 minutes of inactivity it strop to work ?
> > >
> > > If you have any ideas, let me know.
> > >
> > > Thanks a lot.
> > >
> > > David
> > >
> > >
> > > It look similar to this problem :
> > > http://groups.google.ca/group/microsoft.public.platformsdk.complus_mts/browse_thread/thread/da9b915896c6d8a1/66b4518597052cfb?lnk=st&q=&rnum=1&hl=en#66b4518597052cfb
> > >
> > > John Bell wrote:
> > > > Hi Dave
> > > >
> > > > I am not sure what you mean by different zones? Is this a different sub-net?
> > > > It is not clear if you are seeing exactly the same symptoms with DTC tester
> > > > or if it never works?
> > > >
> > > > As the problem is intermittent it sounds like a network type issue rather
> > > > than the components. You may want to try changing network cards and
> > > > hubs/switches to see if it continues to fail. Also if there are any firewalls
> > > > make sure they are configured correctly, also make sure that no antivirus or
> > > > intrusion detection software is causing a conflict.
> > > >
> > > > John
> > > >
> > > >
> > > > "Dave960" wrote:
> > > >
> > > > > I have a Windows 2003 Application Server. When I dont use the
> > > > > Application for about 15 minutes, I get the error : "New transaction
> > > > > cannot enlist in the specified transaction coordinator" when trying to
> > > > > do a transaction with the Database server.
> > > > >
> > > > > When I got the error, if I keep trying to do a transaction, eventually
> > > > > the transaction process restart to work until I keep it inactive for
> > > > > about 15 minutes.
> > > > >
> > > > > I did some test with the application and with DTCTester. When it dont
> > > > > work with the application it dont work with DTCTester
> > > > > (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> > > > >
> > > > > - The application server is Windows 2003 SP1
> > > > >
> > > > > - This server connect to a Cluster SQL Server 2000 database intalled on
> > > > > Windows 2003 servers .
> > > > >
> > > > > - The two servers are in two differents Network zone.
> > > > >
> > > > > - All ports are opened between Database servers and application
> > > > > servers.
> > > > >
> > > > > - MSDTC is started on the Application and Database server.
> > > > >
> > > > > - In security configuration of MSDTC of the Application server the
> > > > > option "No Authentication Required is selected". This option is not
> > > > > selected on the Database server because the service pack 1 is not
> > > > > installed.
> > > > >
> > > > > - Database computers names are in the host file of the application
> > > > > server and application server name is in the host file of the SQL
> > > > > Server.
> > > > >
> > > > >
> > > > >
> > > > > I did some test with another Database server (SQL Server 2000 on
> > > > > windows 2000) and it always works, but these two server are in the same
> > > > > zone.
> > > > >
> > > > > I would like to know if someone have an idea why the transaction stop
> > > > > to works after about 15 minutes and restart to work if I keep trying.
> > > > >
> > > > > Thank you very much.
> > > > >
> > > > > David
> > > > >
> > > > >
> > >
> > >
>|||Hi Dave
You may also want to check out
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306843
John
"Dave960" wrote:
> Hi John,
> The application server run COM+ components that use distributed
> transaction for certain type of query to the database.
> This application is already running on another server, we just want to
> switch this application to a new server that is in a different sub-net.
> If there's missing informations, dont hesitate to ask me.
> Thanks !!!
> David
>
> John Bell wrote:
> > Hi Dave
> >
> > It is not clear why you need a distributed transaction, from what you say it
> > is only
> > the one server being used at any one time?
> >
> > John
> >
> >
> >
> > "Dave960" wrote:
> >
> > > Hi John,
> > >
> > > Thank's for your reply :)
> > >
> > > - By different zone I mean different sub-net.
> > > - I'm seeing exactly the same problem with dtctester. After a couple of
> > > try it work's and if I do nothing for about 15 minutes it stop to work
> > > until I try dtctester for a couple of try ( 2 to 20).
> > >
> > > If I run a transaction between the application server and the SQL
> > > server every 5-10 minutes, transaction always work.
> > >
> > > The transaction process always work with another Database server
> > > (Server2) in the same zone as my application server, so I think it's
> > > not hardware related. But there is difference with this second server,
> > > it run on windows 2000 and is not in a cluster.
> > >
> > > If I do the dtctester test with the Database server (Server1 - the one
> > > that I have problem with) with another application server in the Dabase
> > > server sub-net it always works.
> > >
> > > Another thing, I'm always able to retrieve data from the Database
> > > server, I just have problem with transactions.
> > >
> > > >From what I see it look like a network problem, but I dont see why
> > > after about 15 minutes of inactivity it strop to work ?
> > >
> > > If you have any ideas, let me know.
> > >
> > > Thanks a lot.
> > >
> > > David
> > >
> > >
> > > It look similar to this problem :
> > > http://groups.google.ca/group/microsoft.public.platformsdk.complus_mts/browse_thread/thread/da9b915896c6d8a1/66b4518597052cfb?lnk=st&q=&rnum=1&hl=en#66b4518597052cfb
> > >
> > > John Bell wrote:
> > > > Hi Dave
> > > >
> > > > I am not sure what you mean by different zones? Is this a different sub-net?
> > > > It is not clear if you are seeing exactly the same symptoms with DTC tester
> > > > or if it never works?
> > > >
> > > > As the problem is intermittent it sounds like a network type issue rather
> > > > than the components. You may want to try changing network cards and
> > > > hubs/switches to see if it continues to fail. Also if there are any firewalls
> > > > make sure they are configured correctly, also make sure that no antivirus or
> > > > intrusion detection software is causing a conflict.
> > > >
> > > > John
> > > >
> > > >
> > > > "Dave960" wrote:
> > > >
> > > > > I have a Windows 2003 Application Server. When I dont use the
> > > > > Application for about 15 minutes, I get the error : "New transaction
> > > > > cannot enlist in the specified transaction coordinator" when trying to
> > > > > do a transaction with the Database server.
> > > > >
> > > > > When I got the error, if I keep trying to do a transaction, eventually
> > > > > the transaction process restart to work until I keep it inactive for
> > > > > about 15 minutes.
> > > > >
> > > > > I did some test with the application and with DTCTester. When it dont
> > > > > work with the application it dont work with DTCTester
> > > > > (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> > > > >
> > > > > - The application server is Windows 2003 SP1
> > > > >
> > > > > - This server connect to a Cluster SQL Server 2000 database intalled on
> > > > > Windows 2003 servers .
> > > > >
> > > > > - The two servers are in two differents Network zone.
> > > > >
> > > > > - All ports are opened between Database servers and application
> > > > > servers.
> > > > >
> > > > > - MSDTC is started on the Application and Database server.
> > > > >
> > > > > - In security configuration of MSDTC of the Application server the
> > > > > option "No Authentication Required is selected". This option is not
> > > > > selected on the Database server because the service pack 1 is not
> > > > > installed.
> > > > >
> > > > > - Database computers names are in the host file of the application
> > > > > server and application server name is in the host file of the SQL
> > > > > Server.
> > > > >
> > > > >
> > > > >
> > > > > I did some test with another Database server (SQL Server 2000 on
> > > > > windows 2000) and it always works, but these two server are in the same
> > > > > zone.
> > > > >
> > > > > I would like to know if someone have an idea why the transaction stop
> > > > > to works after about 15 minutes and restart to work if I keep trying.
> > > > >
> > > > > Thank you very much.
> > > > >
> > > > > David
> > > > >
> > > > >
> > >
> > >
>|||Hi John,
- I have the same problem if I desactivate the Antivirus sofware.
- I already follow the steps list in this link and DTCPing always
works.
If you have any other ideas, let me know.
Thanks
David
John Bell wrote:
> Hi Dave
> You may also want to check out
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306843
> John
> "Dave960" wrote:
> > Hi John,
> >
> > The application server run COM+ components that use distributed
> > transaction for certain type of query to the database.
> >
> > This application is already running on another server, we just want to
> > switch this application to a new server that is in a different sub-net.
> >
> > If there's missing informations, dont hesitate to ask me.
> >
> > Thanks !!!
> >
> > David
> >
> >
> > John Bell wrote:
> > > Hi Dave
> > >
> > > It is not clear why you need a distributed transaction, from what you say it
> > > is only
> > > the one server being used at any one time?
> > >
> > > John
> > >
> > >
> > >
> > > "Dave960" wrote:
> > >
> > > > Hi John,
> > > >
> > > > Thank's for your reply :)
> > > >
> > > > - By different zone I mean different sub-net.
> > > > - I'm seeing exactly the same problem with dtctester. After a couple of
> > > > try it work's and if I do nothing for about 15 minutes it stop to work
> > > > until I try dtctester for a couple of try ( 2 to 20).
> > > >
> > > > If I run a transaction between the application server and the SQL
> > > > server every 5-10 minutes, transaction always work.
> > > >
> > > > The transaction process always work with another Database server
> > > > (Server2) in the same zone as my application server, so I think it's
> > > > not hardware related. But there is difference with this second server,
> > > > it run on windows 2000 and is not in a cluster.
> > > >
> > > > If I do the dtctester test with the Database server (Server1 - the one
> > > > that I have problem with) with another application server in the Dabase
> > > > server sub-net it always works.
> > > >
> > > > Another thing, I'm always able to retrieve data from the Database
> > > > server, I just have problem with transactions.
> > > >
> > > > >From what I see it look like a network problem, but I dont see why
> > > > after about 15 minutes of inactivity it strop to work ?
> > > >
> > > > If you have any ideas, let me know.
> > > >
> > > > Thanks a lot.
> > > >
> > > > David
> > > >
> > > >
> > > > It look similar to this problem :
> > > > http://groups.google.ca/group/microsoft.public.platformsdk.complus_mts/browse_thread/thread/da9b915896c6d8a1/66b4518597052cfb?lnk=st&q=&rnum=1&hl=en#66b4518597052cfb
> > > >
> > > > John Bell wrote:
> > > > > Hi Dave
> > > > >
> > > > > I am not sure what you mean by different zones? Is this a different sub-net?
> > > > > It is not clear if you are seeing exactly the same symptoms with DTC tester
> > > > > or if it never works?
> > > > >
> > > > > As the problem is intermittent it sounds like a network type issue rather
> > > > > than the components. You may want to try changing network cards and
> > > > > hubs/switches to see if it continues to fail. Also if there are any firewalls
> > > > > make sure they are configured correctly, also make sure that no antivirus or
> > > > > intrusion detection software is causing a conflict.
> > > > >
> > > > > John
> > > > >
> > > > >
> > > > > "Dave960" wrote:
> > > > >
> > > > > > I have a Windows 2003 Application Server. When I dont use the
> > > > > > Application for about 15 minutes, I get the error : "New transaction
> > > > > > cannot enlist in the specified transaction coordinator" when trying to
> > > > > > do a transaction with the Database server.
> > > > > >
> > > > > > When I got the error, if I keep trying to do a transaction, eventually
> > > > > > the transaction process restart to work until I keep it inactive for
> > > > > > about 15 minutes.
> > > > > >
> > > > > > I did some test with the application and with DTCTester. When it dont
> > > > > > work with the application it dont work with DTCTester
> > > > > > (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> > > > > >
> > > > > > - The application server is Windows 2003 SP1
> > > > > >
> > > > > > - This server connect to a Cluster SQL Server 2000 database intalled on
> > > > > > Windows 2003 servers .
> > > > > >
> > > > > > - The two servers are in two differents Network zone.
> > > > > >
> > > > > > - All ports are opened between Database servers and application
> > > > > > servers.
> > > > > >
> > > > > > - MSDTC is started on the Application and Database server.
> > > > > >
> > > > > > - In security configuration of MSDTC of the Application server the
> > > > > > option "No Authentication Required is selected". This option is not
> > > > > > selected on the Database server because the service pack 1 is not
> > > > > > installed.
> > > > > >
> > > > > > - Database computers names are in the host file of the application
> > > > > > server and application server name is in the host file of the SQL
> > > > > > Server.
> > > > > >
> > > > > >
> > > > > >
> > > > > > I did some test with another Database server (SQL Server 2000 on
> > > > > > windows 2000) and it always works, but these two server are in the same
> > > > > > zone.
> > > > > >
> > > > > > I would like to know if someone have an idea why the transaction stop
> > > > > > to works after about 15 minutes and restart to work if I keep trying.
> > > > > >
> > > > > > Thank you very much.
> > > > > >
> > > > > > David
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >
Application for about 15 minutes, I get the error : "New transaction
cannot enlist in the specified transaction coordinator" when trying to
do a transaction with the Database server.
When I got the error, if I keep trying to do a transaction, eventually
the transaction process restart to work until I keep it inactive for
about 15 minutes.
I did some test with the application and with DTCTester. When it dont
work with the application it dont work with DTCTester
(http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
- The application server is Windows 2003 SP1
- This server connect to a Cluster SQL Server 2000 database intalled on
Windows 2003 servers .
- The two servers are in two differents Network zone.
- All ports are opened between Database servers and application
servers.
- MSDTC is started on the Application and Database server.
- In security configuration of MSDTC of the Application server the
option "No Authentication Required is selected". This option is not
selected on the Database server because the service pack 1 is not
installed.
- Database computers names are in the host file of the application
server and application server name is in the host file of the SQL
Server.
I did some test with another Database server (SQL Server 2000 on
windows 2000) and it always works, but these two server are in the same
zone.
I would like to know if someone have an idea why the transaction stop
to works after about 15 minutes and restart to work if I keep trying.
Thank you very much.
DavidHi Dave
I am not sure what you mean by different zones? Is this a different sub-net?
It is not clear if you are seeing exactly the same symptoms with DTC tester
or if it never works?
As the problem is intermittent it sounds like a network type issue rather
than the components. You may want to try changing network cards and
hubs/switches to see if it continues to fail. Also if there are any firewalls
make sure they are configured correctly, also make sure that no antivirus or
intrusion detection software is causing a conflict.
John
"Dave960" wrote:
> I have a Windows 2003 Application Server. When I dont use the
> Application for about 15 minutes, I get the error : "New transaction
> cannot enlist in the specified transaction coordinator" when trying to
> do a transaction with the Database server.
> When I got the error, if I keep trying to do a transaction, eventually
> the transaction process restart to work until I keep it inactive for
> about 15 minutes.
> I did some test with the application and with DTCTester. When it dont
> work with the application it dont work with DTCTester
> (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> - The application server is Windows 2003 SP1
> - This server connect to a Cluster SQL Server 2000 database intalled on
> Windows 2003 servers .
> - The two servers are in two differents Network zone.
> - All ports are opened between Database servers and application
> servers.
> - MSDTC is started on the Application and Database server.
> - In security configuration of MSDTC of the Application server the
> option "No Authentication Required is selected". This option is not
> selected on the Database server because the service pack 1 is not
> installed.
> - Database computers names are in the host file of the application
> server and application server name is in the host file of the SQL
> Server.
>
> I did some test with another Database server (SQL Server 2000 on
> windows 2000) and it always works, but these two server are in the same
> zone.
> I would like to know if someone have an idea why the transaction stop
> to works after about 15 minutes and restart to work if I keep trying.
> Thank you very much.
> David
>|||Hi John,
Thank's for your reply :)
- By different zone I mean different sub-net.
- I'm seeing exactly the same problem with dtctester. After a couple of
try it work's and if I do nothing for about 15 minutes it stop to work
until I try dtctester for a couple of try ( 2 to 20).
If I run a transaction between the application server and the SQL
server every 5-10 minutes, transaction always work.
The transaction process always work with another Database server
(Server2) in the same zone as my application server, so I think it's
not hardware related. But there is difference with this second server,
it run on windows 2000 and is not in a cluster.
If I do the dtctester test with the Database server (Server1 - the one
that I have problem with) with another application server in the Dabase
server sub-net it always works.
Another thing, I'm always able to retrieve data from the Database
server, I just have problem with transactions.
>From what I see it look like a network problem, but I dont see why
after about 15 minutes of inactivity it strop to work ?
If you have any ideas, let me know.
Thanks a lot.
David
It look similar to this problem :
http://groups.google.ca/group/microsoft.public.platformsdk.complus_mts/browse_thread/thread/da9b915896c6d8a1/66b4518597052cfb?lnk=st&q=&rnum=1&hl=en#66b4518597052cfb
John Bell wrote:
> Hi Dave
> I am not sure what you mean by different zones? Is this a different sub-net?
> It is not clear if you are seeing exactly the same symptoms with DTC tester
> or if it never works?
> As the problem is intermittent it sounds like a network type issue rather
> than the components. You may want to try changing network cards and
> hubs/switches to see if it continues to fail. Also if there are any firewalls
> make sure they are configured correctly, also make sure that no antivirus or
> intrusion detection software is causing a conflict.
> John
>
> "Dave960" wrote:
> > I have a Windows 2003 Application Server. When I dont use the
> > Application for about 15 minutes, I get the error : "New transaction
> > cannot enlist in the specified transaction coordinator" when trying to
> > do a transaction with the Database server.
> >
> > When I got the error, if I keep trying to do a transaction, eventually
> > the transaction process restart to work until I keep it inactive for
> > about 15 minutes.
> >
> > I did some test with the application and with DTCTester. When it dont
> > work with the application it dont work with DTCTester
> > (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> >
> > - The application server is Windows 2003 SP1
> >
> > - This server connect to a Cluster SQL Server 2000 database intalled on
> > Windows 2003 servers .
> >
> > - The two servers are in two differents Network zone.
> >
> > - All ports are opened between Database servers and application
> > servers.
> >
> > - MSDTC is started on the Application and Database server.
> >
> > - In security configuration of MSDTC of the Application server the
> > option "No Authentication Required is selected". This option is not
> > selected on the Database server because the service pack 1 is not
> > installed.
> >
> > - Database computers names are in the host file of the application
> > server and application server name is in the host file of the SQL
> > Server.
> >
> >
> >
> > I did some test with another Database server (SQL Server 2000 on
> > windows 2000) and it always works, but these two server are in the same
> > zone.
> >
> > I would like to know if someone have an idea why the transaction stop
> > to works after about 15 minutes and restart to work if I keep trying.
> >
> > Thank you very much.
> >
> > David
> >
> >|||Hi Dave
It is not clear why you need a distributed transaction, from what you say it
is only
the one server being used at any one time?
John
"Dave960" wrote:
> Hi John,
> Thank's for your reply :)
> - By different zone I mean different sub-net.
> - I'm seeing exactly the same problem with dtctester. After a couple of
> try it work's and if I do nothing for about 15 minutes it stop to work
> until I try dtctester for a couple of try ( 2 to 20).
> If I run a transaction between the application server and the SQL
> server every 5-10 minutes, transaction always work.
> The transaction process always work with another Database server
> (Server2) in the same zone as my application server, so I think it's
> not hardware related. But there is difference with this second server,
> it run on windows 2000 and is not in a cluster.
> If I do the dtctester test with the Database server (Server1 - the one
> that I have problem with) with another application server in the Dabase
> server sub-net it always works.
> Another thing, I'm always able to retrieve data from the Database
> server, I just have problem with transactions.
> >From what I see it look like a network problem, but I dont see why
> after about 15 minutes of inactivity it strop to work ?
> If you have any ideas, let me know.
> Thanks a lot.
> David
>
> It look similar to this problem :
> http://groups.google.ca/group/microsoft.public.platformsdk.complus_mts/browse_thread/thread/da9b915896c6d8a1/66b4518597052cfb?lnk=st&q=&rnum=1&hl=en#66b4518597052cfb
> John Bell wrote:
> > Hi Dave
> >
> > I am not sure what you mean by different zones? Is this a different sub-net?
> > It is not clear if you are seeing exactly the same symptoms with DTC tester
> > or if it never works?
> >
> > As the problem is intermittent it sounds like a network type issue rather
> > than the components. You may want to try changing network cards and
> > hubs/switches to see if it continues to fail. Also if there are any firewalls
> > make sure they are configured correctly, also make sure that no antivirus or
> > intrusion detection software is causing a conflict.
> >
> > John
> >
> >
> > "Dave960" wrote:
> >
> > > I have a Windows 2003 Application Server. When I dont use the
> > > Application for about 15 minutes, I get the error : "New transaction
> > > cannot enlist in the specified transaction coordinator" when trying to
> > > do a transaction with the Database server.
> > >
> > > When I got the error, if I keep trying to do a transaction, eventually
> > > the transaction process restart to work until I keep it inactive for
> > > about 15 minutes.
> > >
> > > I did some test with the application and with DTCTester. When it dont
> > > work with the application it dont work with DTCTester
> > > (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> > >
> > > - The application server is Windows 2003 SP1
> > >
> > > - This server connect to a Cluster SQL Server 2000 database intalled on
> > > Windows 2003 servers .
> > >
> > > - The two servers are in two differents Network zone.
> > >
> > > - All ports are opened between Database servers and application
> > > servers.
> > >
> > > - MSDTC is started on the Application and Database server.
> > >
> > > - In security configuration of MSDTC of the Application server the
> > > option "No Authentication Required is selected". This option is not
> > > selected on the Database server because the service pack 1 is not
> > > installed.
> > >
> > > - Database computers names are in the host file of the application
> > > server and application server name is in the host file of the SQL
> > > Server.
> > >
> > >
> > >
> > > I did some test with another Database server (SQL Server 2000 on
> > > windows 2000) and it always works, but these two server are in the same
> > > zone.
> > >
> > > I would like to know if someone have an idea why the transaction stop
> > > to works after about 15 minutes and restart to work if I keep trying.
> > >
> > > Thank you very much.
> > >
> > > David
> > >
> > >
>|||Hi John,
The application server run COM+ components that use distributed
transaction for certain type of query to the database.
This application is already running on another server, we just want to
switch this application to a new server that is in a different sub-net.
If there's missing informations, dont hesitate to ask me.
Thanks !!!
David
John Bell wrote:
> Hi Dave
> It is not clear why you need a distributed transaction, from what you say it
> is only
> the one server being used at any one time?
> John
>
> "Dave960" wrote:
> > Hi John,
> >
> > Thank's for your reply :)
> >
> > - By different zone I mean different sub-net.
> > - I'm seeing exactly the same problem with dtctester. After a couple of
> > try it work's and if I do nothing for about 15 minutes it stop to work
> > until I try dtctester for a couple of try ( 2 to 20).
> >
> > If I run a transaction between the application server and the SQL
> > server every 5-10 minutes, transaction always work.
> >
> > The transaction process always work with another Database server
> > (Server2) in the same zone as my application server, so I think it's
> > not hardware related. But there is difference with this second server,
> > it run on windows 2000 and is not in a cluster.
> >
> > If I do the dtctester test with the Database server (Server1 - the one
> > that I have problem with) with another application server in the Dabase
> > server sub-net it always works.
> >
> > Another thing, I'm always able to retrieve data from the Database
> > server, I just have problem with transactions.
> >
> > >From what I see it look like a network problem, but I dont see why
> > after about 15 minutes of inactivity it strop to work ?
> >
> > If you have any ideas, let me know.
> >
> > Thanks a lot.
> >
> > David
> >
> >
> > It look similar to this problem :
> > http://groups.google.ca/group/microsoft.public.platformsdk.complus_mts/browse_thread/thread/da9b915896c6d8a1/66b4518597052cfb?lnk=st&q=&rnum=1&hl=en#66b4518597052cfb
> >
> > John Bell wrote:
> > > Hi Dave
> > >
> > > I am not sure what you mean by different zones? Is this a different sub-net?
> > > It is not clear if you are seeing exactly the same symptoms with DTC tester
> > > or if it never works?
> > >
> > > As the problem is intermittent it sounds like a network type issue rather
> > > than the components. You may want to try changing network cards and
> > > hubs/switches to see if it continues to fail. Also if there are any firewalls
> > > make sure they are configured correctly, also make sure that no antivirus or
> > > intrusion detection software is causing a conflict.
> > >
> > > John
> > >
> > >
> > > "Dave960" wrote:
> > >
> > > > I have a Windows 2003 Application Server. When I dont use the
> > > > Application for about 15 minutes, I get the error : "New transaction
> > > > cannot enlist in the specified transaction coordinator" when trying to
> > > > do a transaction with the Database server.
> > > >
> > > > When I got the error, if I keep trying to do a transaction, eventually
> > > > the transaction process restart to work until I keep it inactive for
> > > > about 15 minutes.
> > > >
> > > > I did some test with the application and with DTCTester. When it dont
> > > > work with the application it dont work with DTCTester
> > > > (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> > > >
> > > > - The application server is Windows 2003 SP1
> > > >
> > > > - This server connect to a Cluster SQL Server 2000 database intalled on
> > > > Windows 2003 servers .
> > > >
> > > > - The two servers are in two differents Network zone.
> > > >
> > > > - All ports are opened between Database servers and application
> > > > servers.
> > > >
> > > > - MSDTC is started on the Application and Database server.
> > > >
> > > > - In security configuration of MSDTC of the Application server the
> > > > option "No Authentication Required is selected". This option is not
> > > > selected on the Database server because the service pack 1 is not
> > > > installed.
> > > >
> > > > - Database computers names are in the host file of the application
> > > > server and application server name is in the host file of the SQL
> > > > Server.
> > > >
> > > >
> > > >
> > > > I did some test with another Database server (SQL Server 2000 on
> > > > windows 2000) and it always works, but these two server are in the same
> > > > zone.
> > > >
> > > > I would like to know if someone have an idea why the transaction stop
> > > > to works after about 15 minutes and restart to work if I keep trying.
> > > >
> > > > Thank you very much.
> > > >
> > > > David
> > > >
> > > >
> >
> >|||Hi Dave
As this is intermitten, it implies that it is set up correctly and something
other than SQL Server is causing this to fail. Have you checked for intrusion
detection or virus checkers being active at this time?
John
"Dave960" wrote:
> Hi John,
> The application server run COM+ components that use distributed
> transaction for certain type of query to the database.
> This application is already running on another server, we just want to
> switch this application to a new server that is in a different sub-net.
> If there's missing informations, dont hesitate to ask me.
> Thanks !!!
> David
>
> John Bell wrote:
> > Hi Dave
> >
> > It is not clear why you need a distributed transaction, from what you say it
> > is only
> > the one server being used at any one time?
> >
> > John
> >
> >
> >
> > "Dave960" wrote:
> >
> > > Hi John,
> > >
> > > Thank's for your reply :)
> > >
> > > - By different zone I mean different sub-net.
> > > - I'm seeing exactly the same problem with dtctester. After a couple of
> > > try it work's and if I do nothing for about 15 minutes it stop to work
> > > until I try dtctester for a couple of try ( 2 to 20).
> > >
> > > If I run a transaction between the application server and the SQL
> > > server every 5-10 minutes, transaction always work.
> > >
> > > The transaction process always work with another Database server
> > > (Server2) in the same zone as my application server, so I think it's
> > > not hardware related. But there is difference with this second server,
> > > it run on windows 2000 and is not in a cluster.
> > >
> > > If I do the dtctester test with the Database server (Server1 - the one
> > > that I have problem with) with another application server in the Dabase
> > > server sub-net it always works.
> > >
> > > Another thing, I'm always able to retrieve data from the Database
> > > server, I just have problem with transactions.
> > >
> > > >From what I see it look like a network problem, but I dont see why
> > > after about 15 minutes of inactivity it strop to work ?
> > >
> > > If you have any ideas, let me know.
> > >
> > > Thanks a lot.
> > >
> > > David
> > >
> > >
> > > It look similar to this problem :
> > > http://groups.google.ca/group/microsoft.public.platformsdk.complus_mts/browse_thread/thread/da9b915896c6d8a1/66b4518597052cfb?lnk=st&q=&rnum=1&hl=en#66b4518597052cfb
> > >
> > > John Bell wrote:
> > > > Hi Dave
> > > >
> > > > I am not sure what you mean by different zones? Is this a different sub-net?
> > > > It is not clear if you are seeing exactly the same symptoms with DTC tester
> > > > or if it never works?
> > > >
> > > > As the problem is intermittent it sounds like a network type issue rather
> > > > than the components. You may want to try changing network cards and
> > > > hubs/switches to see if it continues to fail. Also if there are any firewalls
> > > > make sure they are configured correctly, also make sure that no antivirus or
> > > > intrusion detection software is causing a conflict.
> > > >
> > > > John
> > > >
> > > >
> > > > "Dave960" wrote:
> > > >
> > > > > I have a Windows 2003 Application Server. When I dont use the
> > > > > Application for about 15 minutes, I get the error : "New transaction
> > > > > cannot enlist in the specified transaction coordinator" when trying to
> > > > > do a transaction with the Database server.
> > > > >
> > > > > When I got the error, if I keep trying to do a transaction, eventually
> > > > > the transaction process restart to work until I keep it inactive for
> > > > > about 15 minutes.
> > > > >
> > > > > I did some test with the application and with DTCTester. When it dont
> > > > > work with the application it dont work with DTCTester
> > > > > (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> > > > >
> > > > > - The application server is Windows 2003 SP1
> > > > >
> > > > > - This server connect to a Cluster SQL Server 2000 database intalled on
> > > > > Windows 2003 servers .
> > > > >
> > > > > - The two servers are in two differents Network zone.
> > > > >
> > > > > - All ports are opened between Database servers and application
> > > > > servers.
> > > > >
> > > > > - MSDTC is started on the Application and Database server.
> > > > >
> > > > > - In security configuration of MSDTC of the Application server the
> > > > > option "No Authentication Required is selected". This option is not
> > > > > selected on the Database server because the service pack 1 is not
> > > > > installed.
> > > > >
> > > > > - Database computers names are in the host file of the application
> > > > > server and application server name is in the host file of the SQL
> > > > > Server.
> > > > >
> > > > >
> > > > >
> > > > > I did some test with another Database server (SQL Server 2000 on
> > > > > windows 2000) and it always works, but these two server are in the same
> > > > > zone.
> > > > >
> > > > > I would like to know if someone have an idea why the transaction stop
> > > > > to works after about 15 minutes and restart to work if I keep trying.
> > > > >
> > > > > Thank you very much.
> > > > >
> > > > > David
> > > > >
> > > > >
> > >
> > >
>|||Hi Dave
You may also want to check out
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306843
John
"Dave960" wrote:
> Hi John,
> The application server run COM+ components that use distributed
> transaction for certain type of query to the database.
> This application is already running on another server, we just want to
> switch this application to a new server that is in a different sub-net.
> If there's missing informations, dont hesitate to ask me.
> Thanks !!!
> David
>
> John Bell wrote:
> > Hi Dave
> >
> > It is not clear why you need a distributed transaction, from what you say it
> > is only
> > the one server being used at any one time?
> >
> > John
> >
> >
> >
> > "Dave960" wrote:
> >
> > > Hi John,
> > >
> > > Thank's for your reply :)
> > >
> > > - By different zone I mean different sub-net.
> > > - I'm seeing exactly the same problem with dtctester. After a couple of
> > > try it work's and if I do nothing for about 15 minutes it stop to work
> > > until I try dtctester for a couple of try ( 2 to 20).
> > >
> > > If I run a transaction between the application server and the SQL
> > > server every 5-10 minutes, transaction always work.
> > >
> > > The transaction process always work with another Database server
> > > (Server2) in the same zone as my application server, so I think it's
> > > not hardware related. But there is difference with this second server,
> > > it run on windows 2000 and is not in a cluster.
> > >
> > > If I do the dtctester test with the Database server (Server1 - the one
> > > that I have problem with) with another application server in the Dabase
> > > server sub-net it always works.
> > >
> > > Another thing, I'm always able to retrieve data from the Database
> > > server, I just have problem with transactions.
> > >
> > > >From what I see it look like a network problem, but I dont see why
> > > after about 15 minutes of inactivity it strop to work ?
> > >
> > > If you have any ideas, let me know.
> > >
> > > Thanks a lot.
> > >
> > > David
> > >
> > >
> > > It look similar to this problem :
> > > http://groups.google.ca/group/microsoft.public.platformsdk.complus_mts/browse_thread/thread/da9b915896c6d8a1/66b4518597052cfb?lnk=st&q=&rnum=1&hl=en#66b4518597052cfb
> > >
> > > John Bell wrote:
> > > > Hi Dave
> > > >
> > > > I am not sure what you mean by different zones? Is this a different sub-net?
> > > > It is not clear if you are seeing exactly the same symptoms with DTC tester
> > > > or if it never works?
> > > >
> > > > As the problem is intermittent it sounds like a network type issue rather
> > > > than the components. You may want to try changing network cards and
> > > > hubs/switches to see if it continues to fail. Also if there are any firewalls
> > > > make sure they are configured correctly, also make sure that no antivirus or
> > > > intrusion detection software is causing a conflict.
> > > >
> > > > John
> > > >
> > > >
> > > > "Dave960" wrote:
> > > >
> > > > > I have a Windows 2003 Application Server. When I dont use the
> > > > > Application for about 15 minutes, I get the error : "New transaction
> > > > > cannot enlist in the specified transaction coordinator" when trying to
> > > > > do a transaction with the Database server.
> > > > >
> > > > > When I got the error, if I keep trying to do a transaction, eventually
> > > > > the transaction process restart to work until I keep it inactive for
> > > > > about 15 minutes.
> > > > >
> > > > > I did some test with the application and with DTCTester. When it dont
> > > > > work with the application it dont work with DTCTester
> > > > > (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> > > > >
> > > > > - The application server is Windows 2003 SP1
> > > > >
> > > > > - This server connect to a Cluster SQL Server 2000 database intalled on
> > > > > Windows 2003 servers .
> > > > >
> > > > > - The two servers are in two differents Network zone.
> > > > >
> > > > > - All ports are opened between Database servers and application
> > > > > servers.
> > > > >
> > > > > - MSDTC is started on the Application and Database server.
> > > > >
> > > > > - In security configuration of MSDTC of the Application server the
> > > > > option "No Authentication Required is selected". This option is not
> > > > > selected on the Database server because the service pack 1 is not
> > > > > installed.
> > > > >
> > > > > - Database computers names are in the host file of the application
> > > > > server and application server name is in the host file of the SQL
> > > > > Server.
> > > > >
> > > > >
> > > > >
> > > > > I did some test with another Database server (SQL Server 2000 on
> > > > > windows 2000) and it always works, but these two server are in the same
> > > > > zone.
> > > > >
> > > > > I would like to know if someone have an idea why the transaction stop
> > > > > to works after about 15 minutes and restart to work if I keep trying.
> > > > >
> > > > > Thank you very much.
> > > > >
> > > > > David
> > > > >
> > > > >
> > >
> > >
>|||Hi John,
- I have the same problem if I desactivate the Antivirus sofware.
- I already follow the steps list in this link and DTCPing always
works.
If you have any other ideas, let me know.
Thanks
David
John Bell wrote:
> Hi Dave
> You may also want to check out
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306843
> John
> "Dave960" wrote:
> > Hi John,
> >
> > The application server run COM+ components that use distributed
> > transaction for certain type of query to the database.
> >
> > This application is already running on another server, we just want to
> > switch this application to a new server that is in a different sub-net.
> >
> > If there's missing informations, dont hesitate to ask me.
> >
> > Thanks !!!
> >
> > David
> >
> >
> > John Bell wrote:
> > > Hi Dave
> > >
> > > It is not clear why you need a distributed transaction, from what you say it
> > > is only
> > > the one server being used at any one time?
> > >
> > > John
> > >
> > >
> > >
> > > "Dave960" wrote:
> > >
> > > > Hi John,
> > > >
> > > > Thank's for your reply :)
> > > >
> > > > - By different zone I mean different sub-net.
> > > > - I'm seeing exactly the same problem with dtctester. After a couple of
> > > > try it work's and if I do nothing for about 15 minutes it stop to work
> > > > until I try dtctester for a couple of try ( 2 to 20).
> > > >
> > > > If I run a transaction between the application server and the SQL
> > > > server every 5-10 minutes, transaction always work.
> > > >
> > > > The transaction process always work with another Database server
> > > > (Server2) in the same zone as my application server, so I think it's
> > > > not hardware related. But there is difference with this second server,
> > > > it run on windows 2000 and is not in a cluster.
> > > >
> > > > If I do the dtctester test with the Database server (Server1 - the one
> > > > that I have problem with) with another application server in the Dabase
> > > > server sub-net it always works.
> > > >
> > > > Another thing, I'm always able to retrieve data from the Database
> > > > server, I just have problem with transactions.
> > > >
> > > > >From what I see it look like a network problem, but I dont see why
> > > > after about 15 minutes of inactivity it strop to work ?
> > > >
> > > > If you have any ideas, let me know.
> > > >
> > > > Thanks a lot.
> > > >
> > > > David
> > > >
> > > >
> > > > It look similar to this problem :
> > > > http://groups.google.ca/group/microsoft.public.platformsdk.complus_mts/browse_thread/thread/da9b915896c6d8a1/66b4518597052cfb?lnk=st&q=&rnum=1&hl=en#66b4518597052cfb
> > > >
> > > > John Bell wrote:
> > > > > Hi Dave
> > > > >
> > > > > I am not sure what you mean by different zones? Is this a different sub-net?
> > > > > It is not clear if you are seeing exactly the same symptoms with DTC tester
> > > > > or if it never works?
> > > > >
> > > > > As the problem is intermittent it sounds like a network type issue rather
> > > > > than the components. You may want to try changing network cards and
> > > > > hubs/switches to see if it continues to fail. Also if there are any firewalls
> > > > > make sure they are configured correctly, also make sure that no antivirus or
> > > > > intrusion detection software is causing a conflict.
> > > > >
> > > > > John
> > > > >
> > > > >
> > > > > "Dave960" wrote:
> > > > >
> > > > > > I have a Windows 2003 Application Server. When I dont use the
> > > > > > Application for about 15 minutes, I get the error : "New transaction
> > > > > > cannot enlist in the specified transaction coordinator" when trying to
> > > > > > do a transaction with the Database server.
> > > > > >
> > > > > > When I got the error, if I keep trying to do a transaction, eventually
> > > > > > the transaction process restart to work until I keep it inactive for
> > > > > > about 15 minutes.
> > > > > >
> > > > > > I did some test with the application and with DTCTester. When it dont
> > > > > > work with the application it dont work with DTCTester
> > > > > > (http://support.microsoft.com/default.aspx?scid=kb;en-us;293799).
> > > > > >
> > > > > > - The application server is Windows 2003 SP1
> > > > > >
> > > > > > - This server connect to a Cluster SQL Server 2000 database intalled on
> > > > > > Windows 2003 servers .
> > > > > >
> > > > > > - The two servers are in two differents Network zone.
> > > > > >
> > > > > > - All ports are opened between Database servers and application
> > > > > > servers.
> > > > > >
> > > > > > - MSDTC is started on the Application and Database server.
> > > > > >
> > > > > > - In security configuration of MSDTC of the Application server the
> > > > > > option "No Authentication Required is selected". This option is not
> > > > > > selected on the Database server because the service pack 1 is not
> > > > > > installed.
> > > > > >
> > > > > > - Database computers names are in the host file of the application
> > > > > > server and application server name is in the host file of the SQL
> > > > > > Server.
> > > > > >
> > > > > >
> > > > > >
> > > > > > I did some test with another Database server (SQL Server 2000 on
> > > > > > windows 2000) and it always works, but these two server are in the same
> > > > > > zone.
> > > > > >
> > > > > > I would like to know if someone have an idea why the transaction stop
> > > > > > to works after about 15 minutes and restart to work if I keep trying.
> > > > > >
> > > > > > Thank you very much.
> > > > > >
> > > > > > David
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >
Wednesday, March 7, 2012
Integrity Check Failure
DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
Log backup and Optimizations are successful. I canâ't determine if itâ's
failing to run or if itâ's running
and finding a problem. The logs are not indicating any reasons for failure.
Integrity check is successful on other DBâ's. Thanks for being there to help.1. Define a report file for the plan and check that report file for error messages.
2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> Log backup and Optimizations are successful. I canâ't determine if itâ's
> failing to run or if itâ's running
> and finding a problem. The logs are not indicating any reasons for failure.
> Integrity check is successful on other DBâ's. Thanks for being there to help.
>|||Thanks Tibor. Can you direct me to a location that indicates the procedure for
defining a report?
"Tibor Karaszi" wrote:
> 1. Define a report file for the plan and check that report file for error messages.
> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> > Log backup and Optimizations are successful. I canâ't determine if itâ's
> > failing to run or if itâ's running
> > and finding a problem. The logs are not indicating any reasons for failure.
> > Integrity check is successful on other DBâ's. Thanks for being there to help.
> >
>|||EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
this option. You can also right-click an existing plan and open (something like) history and try to
find the error messages there. I don't use maint plans, so it is a little bit sketchy...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
> Thanks Tibor. Can you direct me to a location that indicates the procedure for
> defining a report?
> "Tibor Karaszi" wrote:
>> 1. Define a report file for the plan and check that report file for error messages.
>> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
>> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
>> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
>> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
>> > Log backup and Optimizations are successful. I canâ't determine if itâ's
>> > failing to run or if itâ's running
>> > and finding a problem. The logs are not indicating any reasons for failure.
>> > Integrity check is successful on other DBâ's. Thanks for being there to help.
>> >
>>|||Thanks for your help
"Tibor Karaszi" wrote:
> EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
> this option. You can also right-click an existing plan and open (something like) history and try to
> find the error messages there. I don't use maint plans, so it is a little bit sketchy...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
> > Thanks Tibor. Can you direct me to a location that indicates the procedure for
> > defining a report?
> >
> > "Tibor Karaszi" wrote:
> >
> >> 1. Define a report file for the plan and check that report file for error messages.
> >>
> >> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> >>
> >> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> >> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> >> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> >> > Log backup and Optimizations are successful. I canâ't determine if itâ's
> >> > failing to run or if itâ's running
> >> > and finding a problem. The logs are not indicating any reasons for failure.
> >> > Integrity check is successful on other DBâ's. Thanks for being there to help.
> >> >
> >>
> >>
>
Log backup and Optimizations are successful. I canâ't determine if itâ's
failing to run or if itâ's running
and finding a problem. The logs are not indicating any reasons for failure.
Integrity check is successful on other DBâ's. Thanks for being there to help.1. Define a report file for the plan and check that report file for error messages.
2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> Log backup and Optimizations are successful. I canâ't determine if itâ's
> failing to run or if itâ's running
> and finding a problem. The logs are not indicating any reasons for failure.
> Integrity check is successful on other DBâ's. Thanks for being there to help.
>|||Thanks Tibor. Can you direct me to a location that indicates the procedure for
defining a report?
"Tibor Karaszi" wrote:
> 1. Define a report file for the plan and check that report file for error messages.
> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> > Log backup and Optimizations are successful. I canâ't determine if itâ's
> > failing to run or if itâ's running
> > and finding a problem. The logs are not indicating any reasons for failure.
> > Integrity check is successful on other DBâ's. Thanks for being there to help.
> >
>|||EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
this option. You can also right-click an existing plan and open (something like) history and try to
find the error messages there. I don't use maint plans, so it is a little bit sketchy...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
> Thanks Tibor. Can you direct me to a location that indicates the procedure for
> defining a report?
> "Tibor Karaszi" wrote:
>> 1. Define a report file for the plan and check that report file for error messages.
>> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
>> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
>> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
>> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
>> > Log backup and Optimizations are successful. I canâ't determine if itâ's
>> > failing to run or if itâ's running
>> > and finding a problem. The logs are not indicating any reasons for failure.
>> > Integrity check is successful on other DBâ's. Thanks for being there to help.
>> >
>>|||Thanks for your help
"Tibor Karaszi" wrote:
> EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
> this option. You can also right-click an existing plan and open (something like) history and try to
> find the error messages there. I don't use maint plans, so it is a little bit sketchy...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
> > Thanks Tibor. Can you direct me to a location that indicates the procedure for
> > defining a report?
> >
> > "Tibor Karaszi" wrote:
> >
> >> 1. Define a report file for the plan and check that report file for error messages.
> >>
> >> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> >>
> >> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> >> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> >> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> >> > Log backup and Optimizations are successful. I canâ't determine if itâ's
> >> > failing to run or if itâ's running
> >> > and finding a problem. The logs are not indicating any reasons for failure.
> >> > Integrity check is successful on other DBâ's. Thanks for being there to help.
> >> >
> >>
> >>
>
Integrity Check and Transaction Log
Running the Integrity Check (I think this is DBCC CHECKDB)
as part of a Database Maintenance Plan creates a
transaction log that is roughly the size of the database.
This is causing a problem where a large database is
filling up the disk. The simple answer is to get a bigger
disk, but how can I run the Integrity Check and not have
my tlog grow so much? Is this possible?
SQL BOL says "If actively performing transactions while
DBCC CHECKDB is running, the transaction log continues to
grow because the DBCC command blocks log truncation until
it has finished reading the log." However, the integrity
check occurs early in the morning (1am) and there are no
users in the database.
Thanks,
DeanAfter you run the checkdb, you could kick off a full backup then
truncate the log if you do not have users connecting.
HTH
Ray Higdon MCSE, MCDBA, CCNA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||Ray,
Yes, I could do that, and effectively am, only the next
day as part of the DB Maintenance Plan. My question comes
because I can't reproduce this tlog growth on other
databases. I've got several situations where it is
happening, but I can't pin down exactly why it's
occuring. I'm just about sure the DB Maint. Plan is the
culprit because of the timing.
Dean
>--Original Message--
>After you run the checkdb, you could kick off a full
backup then
>truncate the log if you do not have users connecting.
>HTH
>Ray Higdon MCSE, MCDBA, CCNA
>*** Sent via Developersdex http://www.developersdex.com
***
>Don't just participate in USENET...get rewarded for it!
>.
>|||Sounds more like the log is filling up due to the optimization (DBREINDEX)
portion of the MP and not the DBCC CHECKDB.
--
Andrew J. Kelly
SQL Server MVP
"Dean Beckley" <dean@.omegagroup.com> wrote in message
news:02f801c34a46$b1aff210$a401280a@.phx.gbl...
> Ray,
> Yes, I could do that, and effectively am, only the next
> day as part of the DB Maintenance Plan. My question comes
> because I can't reproduce this tlog growth on other
> databases. I've got several situations where it is
> happening, but I can't pin down exactly why it's
> occuring. I'm just about sure the DB Maint. Plan is the
> culprit because of the timing.
> Dean
> >--Original Message--
> >After you run the checkdb, you could kick off a full
> backup then
> >truncate the log if you do not have users connecting.
> >
> >HTH
> >
> >Ray Higdon MCSE, MCDBA, CCNA
> >
> >*** Sent via Developersdex http://www.developersdex.com
> ***
> >Don't just participate in USENET...get rewarded for it!
> >.
> >|||I can guarantee you that CHECKDB itself does not generate log records
(unless you're running repair) so something else _must_ be running at the
same as the check.
Regards,
Paul.
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OkScA8mSDHA.3192@.tk2msftngp13.phx.gbl...
> Sounds more like the log is filling up due to the optimization (DBREINDEX)
> portion of the MP and not the DBCC CHECKDB.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Dean Beckley" <dean@.omegagroup.com> wrote in message
> news:02f801c34a46$b1aff210$a401280a@.phx.gbl...
> > Ray,
> >
> > Yes, I could do that, and effectively am, only the next
> > day as part of the DB Maintenance Plan. My question comes
> > because I can't reproduce this tlog growth on other
> > databases. I've got several situations where it is
> > happening, but I can't pin down exactly why it's
> > occuring. I'm just about sure the DB Maint. Plan is the
> > culprit because of the timing.
> >
> > Dean
> > >--Original Message--
> > >After you run the checkdb, you could kick off a full
> > backup then
> > >truncate the log if you do not have users connecting.
> > >
> > >HTH
> > >
> > >Ray Higdon MCSE, MCDBA, CCNA
> > >
> > >*** Sent via Developersdex http://www.developersdex.com
> > ***
> > >Don't just participate in USENET...get rewarded for it!
> > >.
> > >
>|||Yes, I guess I made it sound more like a question than a statement. DBCC
CHECKDB does not manipulate the data so there is no need to log.
--
Andrew J. Kelly
SQL Server MVP
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:Oxzrk7uSDHA.2276@.TK2MSFTNGP10.phx.gbl...
> I can guarantee you that CHECKDB itself does not generate log records
> (unless you're running repair) so something else _must_ be running at the
> same as the check.
> Regards,
> Paul.
> --
> Paul Randal
> DBCC Technical Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OkScA8mSDHA.3192@.tk2msftngp13.phx.gbl...
> > Sounds more like the log is filling up due to the optimization
(DBREINDEX)
> > portion of the MP and not the DBCC CHECKDB.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Dean Beckley" <dean@.omegagroup.com> wrote in message
> > news:02f801c34a46$b1aff210$a401280a@.phx.gbl...
> > > Ray,
> > >
> > > Yes, I could do that, and effectively am, only the next
> > > day as part of the DB Maintenance Plan. My question comes
> > > because I can't reproduce this tlog growth on other
> > > databases. I've got several situations where it is
> > > happening, but I can't pin down exactly why it's
> > > occuring. I'm just about sure the DB Maint. Plan is the
> > > culprit because of the timing.
> > >
> > > Dean
> > > >--Original Message--
> > > >After you run the checkdb, you could kick off a full
> > > backup then
> > > >truncate the log if you do not have users connecting.
> > > >
> > > >HTH
> > > >
> > > >Ray Higdon MCSE, MCDBA, CCNA
> > > >
> > > >*** Sent via Developersdex http://www.developersdex.com
> > > ***
> > > >Don't just participate in USENET...get rewarded for it!
> > > >.
> > > >
> >
> >
>
as part of a Database Maintenance Plan creates a
transaction log that is roughly the size of the database.
This is causing a problem where a large database is
filling up the disk. The simple answer is to get a bigger
disk, but how can I run the Integrity Check and not have
my tlog grow so much? Is this possible?
SQL BOL says "If actively performing transactions while
DBCC CHECKDB is running, the transaction log continues to
grow because the DBCC command blocks log truncation until
it has finished reading the log." However, the integrity
check occurs early in the morning (1am) and there are no
users in the database.
Thanks,
DeanAfter you run the checkdb, you could kick off a full backup then
truncate the log if you do not have users connecting.
HTH
Ray Higdon MCSE, MCDBA, CCNA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||Ray,
Yes, I could do that, and effectively am, only the next
day as part of the DB Maintenance Plan. My question comes
because I can't reproduce this tlog growth on other
databases. I've got several situations where it is
happening, but I can't pin down exactly why it's
occuring. I'm just about sure the DB Maint. Plan is the
culprit because of the timing.
Dean
>--Original Message--
>After you run the checkdb, you could kick off a full
backup then
>truncate the log if you do not have users connecting.
>HTH
>Ray Higdon MCSE, MCDBA, CCNA
>*** Sent via Developersdex http://www.developersdex.com
***
>Don't just participate in USENET...get rewarded for it!
>.
>|||Sounds more like the log is filling up due to the optimization (DBREINDEX)
portion of the MP and not the DBCC CHECKDB.
--
Andrew J. Kelly
SQL Server MVP
"Dean Beckley" <dean@.omegagroup.com> wrote in message
news:02f801c34a46$b1aff210$a401280a@.phx.gbl...
> Ray,
> Yes, I could do that, and effectively am, only the next
> day as part of the DB Maintenance Plan. My question comes
> because I can't reproduce this tlog growth on other
> databases. I've got several situations where it is
> happening, but I can't pin down exactly why it's
> occuring. I'm just about sure the DB Maint. Plan is the
> culprit because of the timing.
> Dean
> >--Original Message--
> >After you run the checkdb, you could kick off a full
> backup then
> >truncate the log if you do not have users connecting.
> >
> >HTH
> >
> >Ray Higdon MCSE, MCDBA, CCNA
> >
> >*** Sent via Developersdex http://www.developersdex.com
> ***
> >Don't just participate in USENET...get rewarded for it!
> >.
> >|||I can guarantee you that CHECKDB itself does not generate log records
(unless you're running repair) so something else _must_ be running at the
same as the check.
Regards,
Paul.
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OkScA8mSDHA.3192@.tk2msftngp13.phx.gbl...
> Sounds more like the log is filling up due to the optimization (DBREINDEX)
> portion of the MP and not the DBCC CHECKDB.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Dean Beckley" <dean@.omegagroup.com> wrote in message
> news:02f801c34a46$b1aff210$a401280a@.phx.gbl...
> > Ray,
> >
> > Yes, I could do that, and effectively am, only the next
> > day as part of the DB Maintenance Plan. My question comes
> > because I can't reproduce this tlog growth on other
> > databases. I've got several situations where it is
> > happening, but I can't pin down exactly why it's
> > occuring. I'm just about sure the DB Maint. Plan is the
> > culprit because of the timing.
> >
> > Dean
> > >--Original Message--
> > >After you run the checkdb, you could kick off a full
> > backup then
> > >truncate the log if you do not have users connecting.
> > >
> > >HTH
> > >
> > >Ray Higdon MCSE, MCDBA, CCNA
> > >
> > >*** Sent via Developersdex http://www.developersdex.com
> > ***
> > >Don't just participate in USENET...get rewarded for it!
> > >.
> > >
>|||Yes, I guess I made it sound more like a question than a statement. DBCC
CHECKDB does not manipulate the data so there is no need to log.
--
Andrew J. Kelly
SQL Server MVP
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:Oxzrk7uSDHA.2276@.TK2MSFTNGP10.phx.gbl...
> I can guarantee you that CHECKDB itself does not generate log records
> (unless you're running repair) so something else _must_ be running at the
> same as the check.
> Regards,
> Paul.
> --
> Paul Randal
> DBCC Technical Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OkScA8mSDHA.3192@.tk2msftngp13.phx.gbl...
> > Sounds more like the log is filling up due to the optimization
(DBREINDEX)
> > portion of the MP and not the DBCC CHECKDB.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Dean Beckley" <dean@.omegagroup.com> wrote in message
> > news:02f801c34a46$b1aff210$a401280a@.phx.gbl...
> > > Ray,
> > >
> > > Yes, I could do that, and effectively am, only the next
> > > day as part of the DB Maintenance Plan. My question comes
> > > because I can't reproduce this tlog growth on other
> > > databases. I've got several situations where it is
> > > happening, but I can't pin down exactly why it's
> > > occuring. I'm just about sure the DB Maint. Plan is the
> > > culprit because of the timing.
> > >
> > > Dean
> > > >--Original Message--
> > > >After you run the checkdb, you could kick off a full
> > > backup then
> > > >truncate the log if you do not have users connecting.
> > > >
> > > >HTH
> > > >
> > > >Ray Higdon MCSE, MCDBA, CCNA
> > > >
> > > >*** Sent via Developersdex http://www.developersdex.com
> > > ***
> > > >Don't just participate in USENET...get rewarded for it!
> > > >.
> > > >
> >
> >
>
Subscribe to:
Posts (Atom)