More on Runaway Log Files

I had to stop the RS service on our server. It's creating 30 megabyte log
files, once every minute. I can still serve up reports evidently with the
ReportServer service stopped in Control Panel, but I doubt I can publish
reports.
If I start the service, the log files immediately start to pile up.
Any ideas? Any way to just stop logging?
JeffYou should contact PSS for a fix for this issue. Restarting the service
should make the problem go away but it could come back at anytime.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
news:e$H8GRsjEHA.156@.TK2MSFTNGP10.phx.gbl...
> I had to stop the RS service on our server. It's creating 30 megabyte log
> files, once every minute. I can still serve up reports evidently with the
> ReportServer service stopped in Control Panel, but I doubt I can publish
> reports.
> If I start the service, the log files immediately start to pile up.
> Any ideas? Any way to just stop logging?
> Jeff
>|||Hi!
Nice to hear, as we have the same problem.
Would you be so kind to tell me what PSS is and how to contact them?
Armin Mueller
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:erEFxDtjEHA.596@.TK2MSFTNGP11.phx.gbl...
> You should contact PSS for a fix for this issue. Restarting the service
> should make the problem go away but it could come back at anytime.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
> news:e$H8GRsjEHA.156@.TK2MSFTNGP10.phx.gbl...
> > I had to stop the RS service on our server. It's creating 30 megabyte
log
> > files, once every minute. I can still serve up reports evidently with
the
> > ReportServer service stopped in Control Panel, but I doubt I can publish
> > reports.
> >
> > If I start the service, the log files immediately start to pile up.
> >
> > Any ideas? Any way to just stop logging?
> >
> > Jeff
> >
> >
>|||Microsoft Product Support Services. See
http://support.microsoft.com/default.aspx?pr=cntactms&style=home. We are
working on the fix and should have a KB article number by the end of this
week.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Armin Mueller" <armin.mueller@.cosmicos.de> wrote in message
news:%23zEQTD$kEHA.3432@.TK2MSFTNGP14.phx.gbl...
> Hi!
> Nice to hear, as we have the same problem.
> Would you be so kind to tell me what PSS is and how to contact them?
> Armin Mueller
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:erEFxDtjEHA.596@.TK2MSFTNGP11.phx.gbl...
>> You should contact PSS for a fix for this issue. Restarting the service
>> should make the problem go away but it could come back at anytime.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
>> news:e$H8GRsjEHA.156@.TK2MSFTNGP10.phx.gbl...
>> > I had to stop the RS service on our server. It's creating 30 megabyte
> log
>> > files, once every minute. I can still serve up reports evidently with
> the
>> > ReportServer service stopped in Control Panel, but I doubt I can
>> > publish
>> > reports.
>> >
>> > If I start the service, the log files immediately start to pile up.
>> >
>> > Any ideas? Any way to just stop logging?
>> >
>> > Jeff
>> >
>> >
>>
>|||Can you tell me if there's been any progress on the hotfix and/or the KB
article related to this issue?
Thanks,
Shawn
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:ONXc$UFlEHA.536@.TK2MSFTNGP11.phx.gbl...
> Microsoft Product Support Services. See
> http://support.microsoft.com/default.aspx?pr=cntactms&style=home. We are
> working on the fix and should have a KB article number by the end of this
> week.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Armin Mueller" <armin.mueller@.cosmicos.de> wrote in message
> news:%23zEQTD$kEHA.3432@.TK2MSFTNGP14.phx.gbl...
> > Hi!
> >
> > Nice to hear, as we have the same problem.
> >
> > Would you be so kind to tell me what PSS is and how to contact them?
> >
> > Armin Mueller
> >
> > "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> > news:erEFxDtjEHA.596@.TK2MSFTNGP11.phx.gbl...
> >> You should contact PSS for a fix for this issue. Restarting the
service
> >> should make the problem go away but it could come back at anytime.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >>
> >> "Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
> >> news:e$H8GRsjEHA.156@.TK2MSFTNGP10.phx.gbl...
> >> > I had to stop the RS service on our server. It's creating 30 megabyte
> > log
> >> > files, once every minute. I can still serve up reports evidently with
> > the
> >> > ReportServer service stopped in Control Panel, but I doubt I can
> >> > publish
> >> > reports.
> >> >
> >> > If I start the service, the log files immediately start to pile up.
> >> >
> >> > Any ideas? Any way to just stop logging?
> >> >
> >> > Jeff
> >> >
> >> >
> >>
> >>
> >
> >
>|||Yes, the hotfix is now available although the KB article is not finished.
Ask product support for the fix associated with KB 885286.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Hansen" <shansen@.lrs.com> wrote in message
news:%23oPKgdomEHA.1712@.TK2MSFTNGP09.phx.gbl...
> Can you tell me if there's been any progress on the hotfix and/or the KB
> article related to this issue?
> Thanks,
> Shawn
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:ONXc$UFlEHA.536@.TK2MSFTNGP11.phx.gbl...
>> Microsoft Product Support Services. See
>> http://support.microsoft.com/default.aspx?pr=cntactms&style=home. We are
>> working on the fix and should have a KB article number by the end of this
>> week.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Armin Mueller" <armin.mueller@.cosmicos.de> wrote in message
>> news:%23zEQTD$kEHA.3432@.TK2MSFTNGP14.phx.gbl...
>> > Hi!
>> >
>> > Nice to hear, as we have the same problem.
>> >
>> > Would you be so kind to tell me what PSS is and how to contact them?
>> >
>> > Armin Mueller
>> >
>> > "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> > news:erEFxDtjEHA.596@.TK2MSFTNGP11.phx.gbl...
>> >> You should contact PSS for a fix for this issue. Restarting the
> service
>> >> should make the problem go away but it could come back at anytime.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >>
>> >>
>> >> "Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
>> >> news:e$H8GRsjEHA.156@.TK2MSFTNGP10.phx.gbl...
>> >> > I had to stop the RS service on our server. It's creating 30
>> >> > megabyte
>> > log
>> >> > files, once every minute. I can still serve up reports evidently
>> >> > with
>> > the
>> >> > ReportServer service stopped in Control Panel, but I doubt I can
>> >> > publish
>> >> > reports.
>> >> >
>> >> > If I start the service, the log files immediately start to pile up.
>> >> >
>> >> > Any ideas? Any way to just stop logging?
>> >> >
>> >> > Jeff
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>

more info

If I just do a regular Subscription, allowing a new table
to be created a regular way, with the same schema as the
Publisher and creating its own procs and everything, the
snapshot looks alot different. When I do all my custom
stuff, the snapshot data file gets created with spaces in
the words. So "bla" becomes "b l a". When I don't do my
custom stuff, "bla" stays "bla". Don't know if this is
causing my prob, but thought it would be worth mentioning.

>--Original Message--
>sql2k sp3
>Howdy kids. Im using Custom Sync Objects for Replication.
>The Subscriber has a different schema than the Publisher.
>(more columns) So I use sp_addarticle to create the
>article, @.creation_script to create the table,
and "before
>applying the snapshot, apply this script" to create the
>insert Stored Proc. The snapshot runs. The table and proc
>get created correctly. (In the format of the Subscriber.)
>However, I still get an error:
>The process could not bulk copy into table '"transdtl"'.
>Unexpected EOF encountered in BCP data-file
>(Source: NECDEVSQL1 (ODBC); Error number: S1000)
>Below are the scripts neccessary to duplicate my
>environment.
>
>--sync view
>create view SyncTransDTL
>as select
> TransDtlKey ,
> CustomerKey ,
> SerialNbr ,
> TranCode ,
> TransDate ,
> TransDateShort = Convert(varchar(10), TransDate, 101),
> TransDateMonth = Month(TransDate),
> TransDateYear = Year(TransDate),
> TransAmt ,
> RefNbr ,
> MerchName ,
> City ,
> State ,
> RejectReason ,
> PostDate ,
> PostDateShort = Convert(varchar(10), PostDate, 101),
> PostDateMonth = Month(PostDate),
> PostDateYear = Year(PostDate),
> CreateDate ,
> MerchSIC
>from dbo.transdtl
>--article
>sp_addarticle @.publication = 'transdtl'
> , @.article = 'transdtl'
> , @.source_table = 'transdtl'
> , @.destination_table = 'transdtl'
> , @.type = 'logbased manualview'
> , @.sync_object = 'SyncTransDTL'
> , @.Creation_Script = '\\necdevsql2
>\d$\Replication\CreateTables.txt'
>,@.schema_option = 0x00
>,@.status = 8
>,@.ins_cmd = 'CALL sp_MSins_TransDTL'
>,@.del_cmd = 'CALL sp_MSdel_TransDTL'
>,@.upd_cmd = 'MCALL sp_MSupd_TransDTL'
>
>--create table script
>CREATE TABLE [dbo].[TransDtl] (
> [TransDtlKey] [int] NOT NULL ,
> [CustomerKey] [int] NULL ,
> [SerialNbr] [char] (10) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
> [TranCode] [char] (4) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
> [TransDate] [smalldatetime] NULL ,
> [TransDateShort] [char] (10) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
> [TransDateMonth] [tinyint] NULL ,
> [TransDateYear] [smallint] NULL ,
> [TransAmt] [money] NULL ,
> [RefNbr] [char] (23) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
> [MerchName] [varchar] (25) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
> [City] [varchar] (15) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
> [State] [varchar] (3) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
> [RejectReason] [varchar] (15) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
> [PostDate] [datetime] NULL ,
> [PostDateShort] [char] (10) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL ,
> [PostDateMonth] [tinyint] NULL ,
> [PostDateYear] [smallint] NULL ,
> [CreateDate] [datetime] NULL ,
> [MerchSIC] [char] (4) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL
>) ON [PRIMARY]
>GO
> CREATE CLUSTERED INDEX [IX_TransDtl_TransDate] ON
[dbo].
>[TransDtl]([TransDate]) WITH FILLFACTOR = 100 ON
[PRIMARY]
>GO
> CREATE INDEX [IX_TransDtl_PostDate] ON [dbo].[TransDtl]
>([PostDate]) WITH FILLFACTOR = 100 ON [PRIMARY]
>GO
> CREATE INDEX [IX_TransDtl_CustomerKey] ON [dbo].
>[TransDtl]([CustomerKey]) WITH FILLFACTOR = 100 ON
>[PRIMARY]
>GO
> CREATE INDEX [IX_TransDtl_RefNo] ON [dbo].[TransDtl]
>([RefNbr]) WITH FILLFACTOR = 100 ON [PRIMARY]
>GO
> CREATE INDEX [IX_TransDtl_SerialNbr] ON [dbo].[TransDtl]
>([SerialNbr]) WITH FILLFACTOR = 100 ON [PRIMARY]
>GO
>/****** The index created by the following statement is
>for internal use only. ******/
>/****** It is not a real index but exists as statistics
>only. ******/
>if (@.@.microsoftversion > 0x07000000 )
>EXEC ('CREATE STATISTICS [Statistic_MerchSIC] ON [dbo].
>[TransDtl] ([MerchSIC]) ')
>GO
>
>--insert proc script
>create procedure sp_msIns_TransDtl
> @.TransDtlKey int ,
> @.CustomerKey int ,
> @.SerialNbr char (10) ,
> @.TranCode char (4) ,
> @.TransDate smalldatetime ,
> @.TransDateShort char (10) ,
> @.TransDateMonth tinyint ,
> @.TransDateYear smallint ,
> @.TransAmt money ,
> @.RefNbr char (23) ,
> @.MerchName varchar (25) ,
> @.City varchar (15) ,
> @.State varchar (3) ,
> @.RejectReason varchar (15) ,
> @.PostDate datetime ,
> @.PostDateShort char (10) ,
> @.PostDateMonth tinyint ,
> @.PostDateYear smallint ,
> @.CreateDate datetime ,
> @.MerchSIC char (4)
>as
>insert into TransDTL
>(
> TransDtlKey ,
> CustomerKey ,
> SerialNbr ,
> TranCode ,
> TransDate ,
> TransDateShort ,
> TransDateMonth ,
> TransDateYear ,
> TransAmt ,
> RefNbr ,
> MerchName ,
> City ,
> State ,
> RejectReason ,
> PostDate ,
> PostDateShort ,
> PostDateMonth ,
> PostDateYear ,
> CreateDate ,
> MerchSIC
>)
>values
>(
> @.TransDtlKey ,
> @.CustomerKey ,
> @.SerialNbr ,
> @.TranCode ,
> @.TransDate ,
> @.TransDateShort ,
> @.TransDateMonth ,
> @.TransDateYear ,
> @.TransAmt ,
> @.RefNbr ,
> @.MerchName ,
> @.City ,
> @.State ,
> @.RejectReason ,
> @.PostDate ,
> @.PostDateShort ,
> @.PostDateMonth ,
> @.PostDateYear ,
> @.CreateDate ,
> @.MerchSIC
>)
>.
>
Chris,
I used your script and after running sp_refreshsubscriptions everything
worked ok. Spaces get created between letters if I use native format, but
just to check if this was a problem, I tried once with native and once with
character format and both worked fine. I added the stored procedure to the
subscriber by hand, but apart from that it was all the same. Can you try
without the stored proc and use native format, just to check that the bcp is
the same style as the one you are used to? If this still errors, please can
you export some data to a csv file and post it up, just so I am using more
or less the same data.
TIA,
Paul Ibison
|||Paul as usual I appreciate your insights. Character format
wont work as then the option "before applying the
snapshot, exec this script" is not available. Which made
me realize, I also didnt post the schema for the Publisher:
CREATE TABLE [dbo].[TransDtl] (
[TransDtlKey] [int] IDENTITY (1, 1) NOT NULL ,
[CustomerKey] [int] NULL ,
[SerialNbr] [char] (10) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[TranCode] [char] (4) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[TransDate] [smalldatetime] NOT NULL ,
[TransAmt] [money] NOT NULL ,
[RefNbr] [char] (23) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[MerchName] [varchar] (25) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[City] [varchar] (15) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[State] [varchar] (3) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[RejectReason] [varchar] (15) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[PostDate] [datetime] NOT NULL ,
[CreateDate] [datetime] NOT NULL ,
[MerchSIC] [char] (4) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TransDtl] WITH NOCHECK ADD
CONSTRAINT [PK_TransDtl] PRIMARY KEY CLUSTERED
(
[TransDtlKey]
) WITH FILLFACTOR = 100 ON [PRIMARY]
GO
ALTER TABLE [dbo].[TransDtl] ADD
CONSTRAINT [DF_TransDtl_CreateDate] DEFAULT
(getdate()) FOR [CreateDate]
GO
CREATE INDEX [IX_TransDtl_PostDate] ON [dbo].[TransDtl]
([PostDate]) WITH FILLFACTOR = 100 ON [PRIMARY]
GO
CREATE INDEX [IX_TransDtl_SerialNbr] ON [dbo].[TransDtl]
([SerialNbr]) WITH FILLFACTOR = 85 ON [PRIMARY]
GO
CREATE INDEX [IX_TransDtl_TransDate_TranCode] ON [dbo].
[TransDtl]([TransDate], [TranCode]) WITH FILLFACTOR = 95
ON [PRIMARY]
GO

>--Original Message--
>Chris,
>I used your script and after running
sp_refreshsubscriptions everything
>worked ok. Spaces get created between letters if I use
native format, but
>just to check if this was a problem, I tried once with
native and once with
>character format and both worked fine. I added the stored
procedure to the
>subscriber by hand, but apart from that it was all the
same. Can you try
>without the stored proc and use native format, just to
check that the bcp is
>the same style as the one you are used to? If this still
errors, please can
>you export some data to a csv file and post it up, just
so I am using more
>or less the same data.
>TIA,
>Paul Ibison
>
>.
>
|||Paul attached is the data Im using. Ive also attached the snapshot file
which I noticed only includes one of the two rows of data in the table.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%239dkpX%23gEHA.592@.TK2MSFTNGP11.phx.gbl...
> Chris,
> I used your script and after running sp_refreshsubscriptions everything
> worked ok. Spaces get created between letters if I use native format, but
> just to check if this was a problem, I tried once with native and once
with
> character format and both worked fine. I added the stored procedure to the
> subscriber by hand, but apart from that it was all the same. Can you try
> without the stored proc and use native format, just to check that the bcp
is
> the same style as the one you are used to? If this still errors, please
can
> you export some data to a csv file and post it up, just so I am using more
> or less the same data.
> TIA,
> Paul Ibison
>
begin 666 Transdtl.CSV
M,2PQ+#$@.(" @.(" @.(" L=&5S="PR,# T+3 Q+3 Q(# P.C P.C P+#$N,# P
M,"QT97-T(" @.(" @.(" @.(" @.(" @.(" @.("QT97-T+'1E<W0L=&5S+'1E<W0L
M,C P-"TP,2TP,2 P,#HP,#HP,"XP,# L,C P-"TP,2TP,2 P,#HP,#HP,"XP
M,# L=&5S= T*,BPQ+#$@.(" @.(" @.(" L8FQA("PR,# T+3 Q+3 Q(# P.C P
M.C P+#$N,# P,"QT97-T(" @.(" @.(" @.(" @.(" @.(" @.("QT97-T+'1E<W0L
M=&5S+'1E<W0L,C P-"TP,2TP,2 P,#HP,#HP,"XP,# L,C P-"TP,2TP,2 P
2,#HP,#HP,"XP,# L=&5S= T*
`
end
begin 666 transdtl_0.bcp
M`0````0!````,0`@.`" `( `@.`" `( `@.`" `( !T`&4`<P!T`&&4```4`# `
M,0`O`# `,0`O`#(`, `P`#0`! $````$U <````````0)P``= !E`',`= `@.
M`" `( `@.`" `( `@.`" `( `@.`" `( `@.`" `( `@.`" `( `@.``@.`= !E`',`
M= `(`'0`90!S`'0`!@.!T`&4`<P`(`'0`90!S`'0`890````````4 `# `,0`O
M`# `,0`O`#(`, `P`#0`! $````$U <``&&4````````" !T`&4`<P!T``(`
M```$`0```#$`( `@.`" `( `@.`" `( `@.`" `8@.!L`&$`( !AE ``% `P`#$`
M+P`P`#$`+P`R`# `, `T``0!````!-0'````````$"<``'0`90!S`'0`( `@.
M`" `( `@.`" `( `@.`" `( `@.`" `( `@.`" `( `@.`" `( `(`'0`90!S`'0`
M" !T`&4`<P!T``8`= !E`',`" !T`&4`<P!T`&&4````````% `P`#$`+P`P
I`#$`+P`R`# `, `T``0!````!-0'``!AE ````````@.`= !E`',`= ``
`
end

monthtodate and yeartodate

I am creating an application with a report in VB .NET. I have all the data showing up and now I need to create a summary at the bottom of the report to show current, Month To Date, and Year To Date information for formulas and database entries. I have it working to a point. My question is what is the format to write a formula for these two fields to keep the data current even if I am not working in the current month. If I am doing November data it seems to work, but if my date is in October I am not getting the data for October, I am still getting November data. I looked in the Crystal Help file and they suggest to change the date on the computer in the control panel. hmmm.... Not very professional if you ask me. Any help would be great.Look under Report menu in Crystal - you can change the date (last option is "Set Report Print Date/Time").
Change that date and MonthToDate etc will use it for their dependent calculations.
Check the object model under .NET and hopefully that property is exposed and is able to be modified by your .NET code.

dave|||Dave,

Thank you for the reply. I have tried that, but I am still having problems. I can get the current data to show up in the MTD formula but it is not adding it the the previous data for the month. I am sure it is a placement problem but I could be worng there. I am also not getting an accurate sum for a formula that is a division problem. I have ordered a new book to help, but any input you may have would be great. Thank you.

Julie|||Hi Julie,

Here's what I would do:
You know you can create more than one group based on the same report field? Well, you can.
So, say you already have a group to show details date by date, create a group above this based on the same field, but in the "Change Group" options, set the "for each section" option to select 'for each year'.
That will give you a section that will show summary data based on the whole year.

Add another group based on the date, and in the "Change Group" options, set the "for each section" option to select 'for each month'.

The groups may not be in the order you want, so use Report menu, and then Change Group Expert, to define the order:
Should be Group 1 : year
Group 2 : month
Group 3 : day

then create your summaries.

Now in the case of one of my reports, I want data from the current month, even though it's incomplete, so in my report formula for selection by line (Report menu, Edit Selection Formula, Record...)
I use something like this:
(({DATEFIELD} > DateAdd("m", -12, {?Pm-?ReportDate})
and
{DATEFIELD} <= {?Pm-?ReportDate}).
Just bear in mind that if date is 15/12/04, report then goes back to 16/12/03.

IF you want completed months then you need a formula field first, something like this (we'll call it EndDate):

' get first day of current month.
formula = DateValue(Year(CurrentDate), Month(CurrentDate), 1

Then in my record selection formula I'd do this:
(({DATEFIELD} >= DateAdd("m", -12, {@.EndDate})
and
{DATEFIELD} < {@.EndDate}). ' note less than, because must be less than first of current month.........

Hope this helps

dave

monitoring deadlock

On production we r having lot of deadlock errors. How can i monitor this and
identified sps creating this havoc... ?
Perhaps you can use this:
http://support.microsoft.com/?kbid=271509
You might find that this is helpful information as well:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
Keith Kratochvil
"Vikram" <aa@.aa> wrote in message
news:eTt3kRMWGHA.3332@.TK2MSFTNGP02.phx.gbl...
> On production we r having lot of deadlock errors. How can i monitor this
> and
> identified sps creating this havoc... ?
>

monitoring deadlock

On production we r having lot of deadlock errors. How can i monitor this and
identified sps creating this havoc... ?Perhaps you can use this:
http://support.microsoft.com/?kbid=271509
You might find that this is helpful information as well:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
Keith Kratochvil
"Vikram" <aa@.aa> wrote in message
news:eTt3kRMWGHA.3332@.TK2MSFTNGP02.phx.gbl...
> On production we r having lot of deadlock errors. How can i monitor this
> and
> identified sps creating this havoc... ?
>

monitoring deadlock

On production we r having lot of deadlock errors. How can i monitor this and
identified sps creating this havoc... ?SQL profiler - Events Locks - Lock::Deadlock.
Mel|||Look at
http://www.sql-server-performance.com/deadlocks.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servdatabse_5xrn.asp?
http://support.microsoft.com/default.aspx?scid=kb;en-us;832524
Regards
Amish Shah|||Perhaps you can use this:
http://support.microsoft.com/?kbid=271509
You might find that this is helpful information as well:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
Keith Kratochvil
"Vikram" <aa@.aa> wrote in message
news:eTt3kRMWGHA.3332@.TK2MSFTNGP02.phx.gbl...
> On production we r having lot of deadlock errors. How can i monitor this
> and
> identified sps creating this havoc... ?
>