Showing posts with label normally. Show all posts
Showing posts with label normally. Show all posts

Friday, March 30, 2012

OLAP and ASP.NEt

Hi,
I am looking at deploying an ASP.NET site which accesses an OLAP database - Microsoft Analysis Services
My question is how is this normally done:
Straight SQL / Stored Procedures3rd party Adhoc pluginAnything else
If there is anyone out there with experience in using ASP.NET andAnalysis Services I would be interested in hearing how they did it -
Database ArchitectureSystem Architecture
and anypitfalls etc...
Thanks in Advance
Jerry

Following article will provide you some initial thoughts;

http://www.aspfree.com/c/a/MS-SQL-Server/Accessing-OLAP-using-ASP-dot-NET/

|||Hey Jerry,
No stored procedures or SQL for OLAP databases.
We used Office Web COmponents which generates the multi-dimensional queries (MDX) for the user. The architecture is similar to the approach in the following article:
Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP
http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/default.aspx
Posted by recitaluiok at 5:11 AM 0 comments
Labels: , , , , , , , , , , , , , ,

Tuesday, March 20, 2012

Odd Error Upon SqlDataReader.Read() "Invalid length parameter passed to the substring func

An application I developed normally works great, but it seems that when processing a certian record (and none of the others so far), SQL Server throws this error:
"Invalid length parameter passed to the substring function."

Here's the code in question:


orderConnection.Open()
orderReader = orderCommand.ExecuteReader()
setControls(orderReader)
...
Private Sub setControls(ByVal dr As SqlDataReader)
 If (dr.Read()) Then '<--*******problem line*******

The SqlDataReader (orderReader) doesn't blow up or anything until I call .Read() (and, as mentioned, this problem only occurs for one order). What could be happening here?Can you post the Sql the reader is running as well as the relevant fields from the record that is crashing?|||It turns out that the stored procedure the DataReader was using expected names to be in first-name, space, last-name format and the record in question had only a single name (my company isn't normalizing their databases for some reason).

As a general question, though, do DataReaders not actually call a stored procedure until .Read() is called? I mean, I would have expected things to error out at the call to ExecuteReader(). I know that a DataReader forges a forward-only direct connection to the database, but I'm confused as to the underlying mechanics of the function calls.|||I'm not at dba but I think that the ExecuteReader creates a cursor and points it before the first record. When you call Read() it fetches the next record and at that time evaluates the calculated fields such as the one using the substring function.

Posted by recitaluiok at 12:10 AM 0 comments
Labels: , , , , , , , , , , , , , , , , , , ,

Odd deadlock info in errorlog

We have a server where we are actively monitoring deadlocks at the moment.
Normally the info comes out in the expected format but over the last few days
the messages have occasionally been truncated(See end of message)
Is this normal behaivour, I've never seen entries like this before.
Thanks.
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:7 Ec0x402F8098) Value:0x42beba40 Cost0/2710)
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:8 Ec0x3F442098) Value:0x42beb8d0 Cost0/2710)
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:7 Ec0x402F8098) Value:0x42beba40 Cost0/2710)
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec0x40088098) Value:0x42beb92c Cost0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec0x4047E098) Value:0x42beb258 Cost0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec0x4047E098) Value:0x42beb258 Cost0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:6 Ec0x3F270098) Value:0x42beb1a0 Cost0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:7 Ec0x408EC098) Value:0x42beb1fc Cost0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec0x4047E098) Value:0x42beb258 Cost0/2710)
Hi
Trace Flag 1204 has been set.
Search SQL Server BOL for "Trace Flag 1204" for more information.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Watson" wrote:

> We have a server where we are actively monitoring deadlocks at the moment.
> Normally the info comes out in the expected format but over the last few days
> the messages have occasionally been truncated(See end of message)
> Is this normal behaivour, I've never seen entries like this before.
> Thanks.
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:7 Ec0x402F8098) Value:0x42beba40 Cost0/2710)
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:8 Ec0x3F442098) Value:0x42beb8d0 Cost0/2710)
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:7 Ec0x402F8098) Value:0x42beba40 Cost0/2710)
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec0x40088098) Value:0x42beb92c Cost0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec0x4047E098) Value:0x42beb258 Cost0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec0x4047E098) Value:0x42beb258 Cost0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:6 Ec0x3F270098) Value:0x42beb1a0 Cost0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:7 Ec0x408EC098) Value:0x42beb1fc Cost0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec0x4047E098) Value:0x42beb258 Cost0/2710)
>
|||Mike, I know this flag is set as I set it. What I dont get are these are very
truncated messages and not the usual pageful of info that is normally
generated.
(The messages all came in one block, I've not edited out anything here)
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Trace Flag 1204 has been set.
> Search SQL Server BOL for "Trace Flag 1204" for more information.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mike Watson" wrote:
|||See http://support.microsoft.com/?id=832524 for additional info. This
behaviour is normal.
Adrian
"Mike Watson" <MikeWatson@.discussions.microsoft.com> wrote in message
news:E3EC85DA-B1E2-46D6-AC82-C0BA20FDB459@.microsoft.com...[vbcol=seagreen]
> Mike, I know this flag is set as I set it. What I dont get are these are
> very
> truncated messages and not the usual pageful of info that is normally
> generated.
> (The messages all came in one block, I've not edited out anything here)
> "Mike Epprecht (SQL MVP)" wrote:
|||Hi Adrian,
I couldn't find in that link an explanation of that short version of
deadlock entry in errorlog
"Adrian Zajkeskovic" wrote:

> See http://support.microsoft.com/?id=832524 for additional info. This
> behaviour is normal.
> Adrian
>
> "Mike Watson" <MikeWatson@.discussions.microsoft.com> wrote in message
> news:E3EC85DA-B1E2-46D6-AC82-C0BA20FDB459@.microsoft.com...
>
>
Posted by recitaluiok at 12:06 AM 0 comments
Labels: , , , , , , , , , , , , , ,

Odd deadlock info in errorlog

We have a server where we are actively monitoring deadlocks at the moment.
Normally the info comes out in the expected format but over the last few days
the messages have occasionally been truncated(See end of message)
Is this normal behaivour, I've never seen entries like this before.
Thanks.
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:8 Ec:(0x3F442098) Value:0x42beb8d0 Cost:(0/2710)
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec:(0x40088098) Value:0x42beb92c Cost:(0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:6 Ec:(0x3F270098) Value:0x42beb1a0 Cost:(0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:7 Ec:(0x408EC098) Value:0x42beb1fc Cost:(0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)Hi
Trace Flag 1204 has been set.
Search SQL Server BOL for "Trace Flag 1204" for more information.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Watson" wrote:
> We have a server where we are actively monitoring deadlocks at the moment.
> Normally the info comes out in the expected format but over the last few days
> the messages have occasionally been truncated(See end of message)
> Is this normal behaivour, I've never seen entries like this before.
> Thanks.
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:8 Ec:(0x3F442098) Value:0x42beb8d0 Cost:(0/2710)
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec:(0x40088098) Value:0x42beb92c Cost:(0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:6 Ec:(0x3F270098) Value:0x42beb1a0 Cost:(0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:7 Ec:(0x408EC098) Value:0x42beb1fc Cost:(0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
>|||Mike, I know this flag is set as I set it. What I dont get are these are very
truncated messages and not the usual pageful of info that is normally
generated.
(The messages all came in one block, I've not edited out anything here)
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Trace Flag 1204 has been set.
> Search SQL Server BOL for "Trace Flag 1204" for more information.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mike Watson" wrote:
> > We have a server where we are actively monitoring deadlocks at the moment.
> > Normally the info comes out in the expected format but over the last few days
> > the messages have occasionally been truncated(See end of message)
> >
> > Is this normal behaivour, I've never seen entries like this before.
> >
> > Thanks.
> >
> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:8 Ec:(0x3F442098) Value:0x42beb8d0 Cost:(0/2710)
> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:5 Ec:(0x40088098) Value:0x42beb92c Cost:(0/2710)
> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:6 Ec:(0x3F270098) Value:0x42beb1a0 Cost:(0/2710)
> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:7 Ec:(0x408EC098) Value:0x42beb1fc Cost:(0/2710)
> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> >|||See http://support.microsoft.com/?id=832524 for additional info. This
behaviour is normal.
Adrian
"Mike Watson" <MikeWatson@.discussions.microsoft.com> wrote in message
news:E3EC85DA-B1E2-46D6-AC82-C0BA20FDB459@.microsoft.com...
> Mike, I know this flag is set as I set it. What I dont get are these are
> very
> truncated messages and not the usual pageful of info that is normally
> generated.
> (The messages all came in one block, I've not edited out anything here)
> "Mike Epprecht (SQL MVP)" wrote:
>> Hi
>> Trace Flag 1204 has been set.
>> Search SQL Server BOL for "Trace Flag 1204" for more information.
>> --
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Mike Watson" wrote:
>> > We have a server where we are actively monitoring deadlocks at the
>> > moment.
>> > Normally the info comes out in the expected format but over the last
>> > few days
>> > the messages have occasionally been truncated(See end of message)
>> >
>> > Is this normal behaivour, I've never seen entries like this before.
>> >
>> > Thanks.
>> >
>> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
>> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:8 Ec:(0x3F442098) Value:0x42beb8d0 Cost:(0/2710)
>> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
>> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:5 Ec:(0x40088098) Value:0x42beb92c Cost:(0/2710)
>> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
>> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
>> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:6 Ec:(0x3F270098) Value:0x42beb1a0 Cost:(0/2710)
>> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:7 Ec:(0x408EC098) Value:0x42beb1fc Cost:(0/2710)
>> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
>> >|||Hi Adrian,
I couldn't find in that link an explanation of that short version of
deadlock entry in errorlog
"Adrian Zajkeskovic" wrote:
> See http://support.microsoft.com/?id=832524 for additional info. This
> behaviour is normal.
> Adrian
>
> "Mike Watson" <MikeWatson@.discussions.microsoft.com> wrote in message
> news:E3EC85DA-B1E2-46D6-AC82-C0BA20FDB459@.microsoft.com...
> > Mike, I know this flag is set as I set it. What I dont get are these are
> > very
> > truncated messages and not the usual pageful of info that is normally
> > generated.
> >
> > (The messages all came in one block, I've not edited out anything here)
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> >> Hi
> >>
> >> Trace Flag 1204 has been set.
> >>
> >> Search SQL Server BOL for "Trace Flag 1204" for more information.
> >> --
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >>
> >>
> >> "Mike Watson" wrote:
> >>
> >> > We have a server where we are actively monitoring deadlocks at the
> >> > moment.
> >> > Normally the info comes out in the expected format but over the last
> >> > few days
> >> > the messages have occasionally been truncated(See end of message)
> >> >
> >> > Is this normal behaivour, I've never seen entries like this before.
> >> >
> >> > Thanks.
> >> >
> >> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
> >> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:8 Ec:(0x3F442098) Value:0x42beb8d0 Cost:(0/2710)
> >> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
> >> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:5 Ec:(0x40088098) Value:0x42beb92c Cost:(0/2710)
> >> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> >> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> >> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:6 Ec:(0x3F270098) Value:0x42beb1a0 Cost:(0/2710)
> >> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:7 Ec:(0x408EC098) Value:0x42beb1fc Cost:(0/2710)
> >> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> >> >
>
>
Posted by recitaluiok at 12:05 AM 0 comments
Labels: , , , , , , , , , , , , , ,

Odd deadlock info in errorlog

We have a server where we are actively monitoring deadlocks at the moment.
Normally the info comes out in the expected format but over the last few day
s
the messages have occasionally been truncated(See end of message)
Is this normal behaivour, I've never seen entries like this before.
Thanks.
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:7 Ec0x402F8098) Value:0x42beba40 Cost0/2710)
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:8 Ec0x3F442098) Value:0x42beb8d0 Cost0/2710)
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:7 Ec0x402F8098) Value:0x42beba40 Cost0/2710)
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec0x40088098) Value:0x42beb92c Cost0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec0x4047E098) Value:0x42beb258 Cost0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec0x4047E098) Value:0x42beb258 Cost0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:6 Ec0x3F270098) Value:0x42beb1a0 Cost0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:7 Ec0x408EC098) Value:0x42beb1fc Cost0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec0x4047E098) Value:0x42beb258 Cost0/2710)Hi
Trace Flag 1204 has been set.
Search SQL Server BOL for "Trace Flag 1204" for more information.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Watson" wrote:

> We have a server where we are actively monitoring deadlocks at the moment.
> Normally the info comes out in the expected format but over the last few d
ays
> the messages have occasionally been truncated(See end of message)
> Is this normal behaivour, I've never seen entries like this before.
> Thanks.
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:7 Ec0x402F8098) Value:0x42beba40 Cost0/2710)
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:8 Ec0x3F442098) Value:0x42beb8d0 Cost0/2710)
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:7 Ec0x402F8098) Value:0x42beba40 Cost0/2710)
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec0x40088098) Value:0x42beb92c Cost0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec0x4047E098) Value:0x42beb258 Cost0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec0x4047E098) Value:0x42beb258 Cost0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:6 Ec0x3F270098) Value:0x42beb1a0 Cost0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:7 Ec0x408EC098) Value:0x42beb1fc Cost0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec0x4047E098) Value:0x42beb258 Cost0/2710)
>|||Mike, I know this flag is set as I set it. What I dont get are these are ver
y
truncated messages and not the usual pageful of info that is normally
generated.
(The messages all came in one block, I've not edited out anything here)
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Trace Flag 1204 has been set.
> Search SQL Server BOL for "Trace Flag 1204" for more information.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mike Watson" wrote:
>|||See http://support.microsoft.com/?id=832524 for additional info. This
behaviour is normal.
Adrian
"Mike Watson" <MikeWatson@.discussions.microsoft.com> wrote in message
news:E3EC85DA-B1E2-46D6-AC82-C0BA20FDB459@.microsoft.com...[vbcol=seagreen]
> Mike, I know this flag is set as I set it. What I dont get are these are
> very
> truncated messages and not the usual pageful of info that is normally
> generated.
> (The messages all came in one block, I've not edited out anything here)
> "Mike Epprecht (SQL MVP)" wrote:
>|||Hi Adrian,
I couldn't find in that link an explanation of that short version of
deadlock entry in errorlog
"Adrian Zajkeskovic" wrote:

> See http://support.microsoft.com/?id=832524 for additional info. This
> behaviour is normal.
> Adrian
>
> "Mike Watson" <MikeWatson@.discussions.microsoft.com> wrote in message
> news:E3EC85DA-B1E2-46D6-AC82-C0BA20FDB459@.microsoft.com...
>
>
Posted by recitaluiok at 12:05 AM 0 comments
Labels: , , , , , , , , , , , , , ,
Subscribe to: Posts (Atom)