We'w got major performance problems with inserting data into large tables
(more than 25 000 000 rows) after installing the latest sp. The performance
decreased with more than 90%.
Our program takes one row at the time and creates inserts and updates for
aproximatly 7 tables out of this. Everyr read row is encapsuled in an
transaction.
occassionaly we can capture an error during insert. The error is 1222.
Have anybody encounted the same problem an even got any solution.
ThanksHi
1222 = "Lock request time out period exceeded."
Run profiler and see what is happening on your server during the loads.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stefan W" wrote:
> We'w got major performance problems with inserting data into large tables
> (more than 25 000 000 rows) after installing the latest sp. The performanc
e
> decreased with more than 90%.
> Our program takes one row at the time and creates inserts and updates for
> aproximatly 7 tables out of this. Everyr read row is encapsuled in an
> transaction.
>
> occassionaly we can capture an error during insert. The error is 1222.
>
> Have anybody encounted the same problem an even got any solution.
> Thanks|||Hi!
I've tried to do that, but i cant get information from the particular job.
The job is desiged as a stored procedure that contains a loop that calls
other stored procedures. Iv'e tried using the different templates provided i
n
the profiler but a don't se any of the underlying procedurecalls made in thi
s
job. Do you have any suggestions on how to set up the profiler to get hand o
n
these jobs!
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> 1222 = "Lock request time out period exceeded."
> Run profiler and see what is happening on your server during the loads.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Stefan W" wrote:
>|||I will suggest to roll back to SP3a.
We have have many problems with SP4 as many other people; check other posts
related to SP4 and you will follow my advice.
Cheers, Massimo
Software Engineer
TCF - Amsterdam (NL)
"Stefan W" wrote:
[vbcol=seagreen]
> Hi!
> I've tried to do that, but i cant get information from the particular job.
> The job is desiged as a stored procedure that contains a loop that calls
> other stored procedures. Iv'e tried using the different templates provided
in
> the profiler but a don't se any of the underlying procedurecalls made in t
his
> job. Do you have any suggestions on how to set up the profiler to get hand
on
> these jobs!
>
>
> "Mike Epprecht (SQL MVP)" wrote:
>|||Hi
Massimo, have you raised a case with Microsoft PSS? If not, you should.
There have been a few posts on performance issues, and they had mostly to do
with a change in the way data type precedence is handled in SP4. I have 78
servers that are on SP4 with 2040 hotfix and none exhibit performance
problems.
Looks to be very application specific.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Massimo" <Massimo@.discussions.microsoft.com> wrote in message
news:640255E5-1885-4210-B9A1-32641D9C17A6@.microsoft.com...[vbcol=seagreen]
>I will suggest to roll back to SP3a.
> We have have many problems with SP4 as many other people; check other
> posts
> related to SP4 and you will follow my advice.
> Cheers, Massimo
> --
> Software Engineer
> TCF - Amsterdam (NL)
>
> "Stefan W" wrote:
>
Showing posts with label major. Show all posts
Showing posts with label major. Show all posts
Tuesday, March 20, 2012
Performance problem after sql2k sp4 installed
We'w got major performance problems with inserting data into large tables
(more than 25 000 000 rows) after installing the latest sp. The performance
decreased with more than 90%.
Our program takes one row at the time and creates inserts and updates for
aproximatly 7 tables out of this. Everyr read row is encapsuled in an
transaction.
occassionaly we can capture an error during insert. The error is 1222.
Have anybody encounted the same problem an even got any solution.
Thanks
Hi
1222 = "Lock request time out period exceeded."
Run profiler and see what is happening on your server during the loads.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stefan W" wrote:
> We'w got major performance problems with inserting data into large tables
> (more than 25 000 000 rows) after installing the latest sp. The performance
> decreased with more than 90%.
> Our program takes one row at the time and creates inserts and updates for
> aproximatly 7 tables out of this. Everyr read row is encapsuled in an
> transaction.
>
> occassionaly we can capture an error during insert. The error is 1222.
>
> Have anybody encounted the same problem an even got any solution.
> Thanks
|||Hi!
I've tried to do that, but i cant get information from the particular job.
The job is desiged as a stored procedure that contains a loop that calls
other stored procedures. Iv'e tried using the different templates provided in
the profiler but a don't se any of the underlying procedurecalls made in this
job. Do you have any suggestions on how to set up the profiler to get hand on
these jobs!
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> 1222 = "Lock request time out period exceeded."
> Run profiler and see what is happening on your server during the loads.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Stefan W" wrote:
|||I will suggest to roll back to SP3a.
We have have many problems with SP4 as many other people; check other posts
related to SP4 and you will follow my advice.
Cheers, Massimo
Software Engineer
TCF - Amsterdam (NL)
"Stefan W" wrote:
[vbcol=seagreen]
> Hi!
> I've tried to do that, but i cant get information from the particular job.
> The job is desiged as a stored procedure that contains a loop that calls
> other stored procedures. Iv'e tried using the different templates provided in
> the profiler but a don't se any of the underlying procedurecalls made in this
> job. Do you have any suggestions on how to set up the profiler to get hand on
> these jobs!
>
>
> "Mike Epprecht (SQL MVP)" wrote:
|||Hi
Massimo, have you raised a case with Microsoft PSS? If not, you should.
There have been a few posts on performance issues, and they had mostly to do
with a change in the way data type precedence is handled in SP4. I have 78
servers that are on SP4 with 2040 hotfix and none exhibit performance
problems.
Looks to be very application specific.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Massimo" <Massimo@.discussions.microsoft.com> wrote in message
news:640255E5-1885-4210-B9A1-32641D9C17A6@.microsoft.com...[vbcol=seagreen]
>I will suggest to roll back to SP3a.
> We have have many problems with SP4 as many other people; check other
> posts
> related to SP4 and you will follow my advice.
> Cheers, Massimo
> --
> Software Engineer
> TCF - Amsterdam (NL)
>
> "Stefan W" wrote:
(more than 25 000 000 rows) after installing the latest sp. The performance
decreased with more than 90%.
Our program takes one row at the time and creates inserts and updates for
aproximatly 7 tables out of this. Everyr read row is encapsuled in an
transaction.
occassionaly we can capture an error during insert. The error is 1222.
Have anybody encounted the same problem an even got any solution.
Thanks
Hi
1222 = "Lock request time out period exceeded."
Run profiler and see what is happening on your server during the loads.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stefan W" wrote:
> We'w got major performance problems with inserting data into large tables
> (more than 25 000 000 rows) after installing the latest sp. The performance
> decreased with more than 90%.
> Our program takes one row at the time and creates inserts and updates for
> aproximatly 7 tables out of this. Everyr read row is encapsuled in an
> transaction.
>
> occassionaly we can capture an error during insert. The error is 1222.
>
> Have anybody encounted the same problem an even got any solution.
> Thanks
|||Hi!
I've tried to do that, but i cant get information from the particular job.
The job is desiged as a stored procedure that contains a loop that calls
other stored procedures. Iv'e tried using the different templates provided in
the profiler but a don't se any of the underlying procedurecalls made in this
job. Do you have any suggestions on how to set up the profiler to get hand on
these jobs!
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> 1222 = "Lock request time out period exceeded."
> Run profiler and see what is happening on your server during the loads.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Stefan W" wrote:
|||I will suggest to roll back to SP3a.
We have have many problems with SP4 as many other people; check other posts
related to SP4 and you will follow my advice.
Cheers, Massimo
Software Engineer
TCF - Amsterdam (NL)
"Stefan W" wrote:
[vbcol=seagreen]
> Hi!
> I've tried to do that, but i cant get information from the particular job.
> The job is desiged as a stored procedure that contains a loop that calls
> other stored procedures. Iv'e tried using the different templates provided in
> the profiler but a don't se any of the underlying procedurecalls made in this
> job. Do you have any suggestions on how to set up the profiler to get hand on
> these jobs!
>
>
> "Mike Epprecht (SQL MVP)" wrote:
|||Hi
Massimo, have you raised a case with Microsoft PSS? If not, you should.
There have been a few posts on performance issues, and they had mostly to do
with a change in the way data type precedence is handled in SP4. I have 78
servers that are on SP4 with 2040 hotfix and none exhibit performance
problems.
Looks to be very application specific.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Massimo" <Massimo@.discussions.microsoft.com> wrote in message
news:640255E5-1885-4210-B9A1-32641D9C17A6@.microsoft.com...[vbcol=seagreen]
>I will suggest to roll back to SP3a.
> We have have many problems with SP4 as many other people; check other
> posts
> related to SP4 and you will follow my advice.
> Cheers, Massimo
> --
> Software Engineer
> TCF - Amsterdam (NL)
>
> "Stefan W" wrote:
Performance problem after sql2k sp4 installed
We'w got major performance problems with inserting data into large tables
(more than 25 000 000 rows) after installing the latest sp. The performance
decreased with more than 90%.
Our program takes one row at the time and creates inserts and updates for
aproximatly 7 tables out of this. Everyr read row is encapsuled in an
transaction.
occassionaly we can capture an error during insert. The error is 1222.
Have anybody encounted the same problem an even got any solution.
ThanksHi
1222 = "Lock request time out period exceeded."
Run profiler and see what is happening on your server during the loads.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stefan W" wrote:
> We'w got major performance problems with inserting data into large tables
> (more than 25 000 000 rows) after installing the latest sp. The performance
> decreased with more than 90%.
> Our program takes one row at the time and creates inserts and updates for
> aproximatly 7 tables out of this. Everyr read row is encapsuled in an
> transaction.
>
> occassionaly we can capture an error during insert. The error is 1222.
>
> Have anybody encounted the same problem an even got any solution.
> Thanks|||Hi!
I've tried to do that, but i cant get information from the particular job.
The job is desiged as a stored procedure that contains a loop that calls
other stored procedures. Iv'e tried using the different templates provided in
the profiler but a don't se any of the underlying procedurecalls made in this
job. Do you have any suggestions on how to set up the profiler to get hand on
these jobs!
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> 1222 = "Lock request time out period exceeded."
> Run profiler and see what is happening on your server during the loads.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Stefan W" wrote:
> > We'w got major performance problems with inserting data into large tables
> > (more than 25 000 000 rows) after installing the latest sp. The performance
> > decreased with more than 90%.
> >
> > Our program takes one row at the time and creates inserts and updates for
> > aproximatly 7 tables out of this. Everyr read row is encapsuled in an
> > transaction.
> >
> >
> > occassionaly we can capture an error during insert. The error is 1222.
> >
> >
> > Have anybody encounted the same problem an even got any solution.
> >
> > Thanks|||I will suggest to roll back to SP3a.
We have have many problems with SP4 as many other people; check other posts
related to SP4 and you will follow my advice.
Cheers, Massimo
--
Software Engineer
TCF - Amsterdam (NL)
"Stefan W" wrote:
> Hi!
> I've tried to do that, but i cant get information from the particular job.
> The job is desiged as a stored procedure that contains a loop that calls
> other stored procedures. Iv'e tried using the different templates provided in
> the profiler but a don't se any of the underlying procedurecalls made in this
> job. Do you have any suggestions on how to set up the profiler to get hand on
> these jobs!
>
>
> "Mike Epprecht (SQL MVP)" wrote:
> > Hi
> >
> > 1222 = "Lock request time out period exceeded."
> >
> > Run profiler and see what is happening on your server during the loads.
> >
> > Regards
> > --
> > Mike Epprecht, Microsoft SQL Server MVP
> > Zurich, Switzerland
> >
> > MVP Program: http://www.microsoft.com/mvp
> >
> > Blog: http://www.msmvps.com/epprecht/
> >
> >
> >
> > "Stefan W" wrote:
> >
> > > We'w got major performance problems with inserting data into large tables
> > > (more than 25 000 000 rows) after installing the latest sp. The performance
> > > decreased with more than 90%.
> > >
> > > Our program takes one row at the time and creates inserts and updates for
> > > aproximatly 7 tables out of this. Everyr read row is encapsuled in an
> > > transaction.
> > >
> > >
> > > occassionaly we can capture an error during insert. The error is 1222.
> > >
> > >
> > > Have anybody encounted the same problem an even got any solution.
> > >
> > > Thanks|||Hi
Massimo, have you raised a case with Microsoft PSS? If not, you should.
There have been a few posts on performance issues, and they had mostly to do
with a change in the way data type precedence is handled in SP4. I have 78
servers that are on SP4 with 2040 hotfix and none exhibit performance
problems.
Looks to be very application specific.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Massimo" <Massimo@.discussions.microsoft.com> wrote in message
news:640255E5-1885-4210-B9A1-32641D9C17A6@.microsoft.com...
>I will suggest to roll back to SP3a.
> We have have many problems with SP4 as many other people; check other
> posts
> related to SP4 and you will follow my advice.
> Cheers, Massimo
> --
> Software Engineer
> TCF - Amsterdam (NL)
>
> "Stefan W" wrote:
>> Hi!
>> I've tried to do that, but i cant get information from the particular
>> job.
>> The job is desiged as a stored procedure that contains a loop that calls
>> other stored procedures. Iv'e tried using the different templates
>> provided in
>> the profiler but a don't se any of the underlying procedurecalls made in
>> this
>> job. Do you have any suggestions on how to set up the profiler to get
>> hand on
>> these jobs!
>>
>>
>> "Mike Epprecht (SQL MVP)" wrote:
>> > Hi
>> >
>> > 1222 = "Lock request time out period exceeded."
>> >
>> > Run profiler and see what is happening on your server during the loads.
>> >
>> > Regards
>> > --
>> > Mike Epprecht, Microsoft SQL Server MVP
>> > Zurich, Switzerland
>> >
>> > MVP Program: http://www.microsoft.com/mvp
>> >
>> > Blog: http://www.msmvps.com/epprecht/
>> >
>> >
>> >
>> > "Stefan W" wrote:
>> >
>> > > We'w got major performance problems with inserting data into large
>> > > tables
>> > > (more than 25 000 000 rows) after installing the latest sp. The
>> > > performance
>> > > decreased with more than 90%.
>> > >
>> > > Our program takes one row at the time and creates inserts and updates
>> > > for
>> > > aproximatly 7 tables out of this. Everyr read row is encapsuled in an
>> > > transaction.
>> > >
>> > >
>> > > occassionaly we can capture an error during insert. The error is
>> > > 1222.
>> > >
>> > >
>> > > Have anybody encounted the same problem an even got any solution.
>> > >
>> > > Thanks
(more than 25 000 000 rows) after installing the latest sp. The performance
decreased with more than 90%.
Our program takes one row at the time and creates inserts and updates for
aproximatly 7 tables out of this. Everyr read row is encapsuled in an
transaction.
occassionaly we can capture an error during insert. The error is 1222.
Have anybody encounted the same problem an even got any solution.
ThanksHi
1222 = "Lock request time out period exceeded."
Run profiler and see what is happening on your server during the loads.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stefan W" wrote:
> We'w got major performance problems with inserting data into large tables
> (more than 25 000 000 rows) after installing the latest sp. The performance
> decreased with more than 90%.
> Our program takes one row at the time and creates inserts and updates for
> aproximatly 7 tables out of this. Everyr read row is encapsuled in an
> transaction.
>
> occassionaly we can capture an error during insert. The error is 1222.
>
> Have anybody encounted the same problem an even got any solution.
> Thanks|||Hi!
I've tried to do that, but i cant get information from the particular job.
The job is desiged as a stored procedure that contains a loop that calls
other stored procedures. Iv'e tried using the different templates provided in
the profiler but a don't se any of the underlying procedurecalls made in this
job. Do you have any suggestions on how to set up the profiler to get hand on
these jobs!
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> 1222 = "Lock request time out period exceeded."
> Run profiler and see what is happening on your server during the loads.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Stefan W" wrote:
> > We'w got major performance problems with inserting data into large tables
> > (more than 25 000 000 rows) after installing the latest sp. The performance
> > decreased with more than 90%.
> >
> > Our program takes one row at the time and creates inserts and updates for
> > aproximatly 7 tables out of this. Everyr read row is encapsuled in an
> > transaction.
> >
> >
> > occassionaly we can capture an error during insert. The error is 1222.
> >
> >
> > Have anybody encounted the same problem an even got any solution.
> >
> > Thanks|||I will suggest to roll back to SP3a.
We have have many problems with SP4 as many other people; check other posts
related to SP4 and you will follow my advice.
Cheers, Massimo
--
Software Engineer
TCF - Amsterdam (NL)
"Stefan W" wrote:
> Hi!
> I've tried to do that, but i cant get information from the particular job.
> The job is desiged as a stored procedure that contains a loop that calls
> other stored procedures. Iv'e tried using the different templates provided in
> the profiler but a don't se any of the underlying procedurecalls made in this
> job. Do you have any suggestions on how to set up the profiler to get hand on
> these jobs!
>
>
> "Mike Epprecht (SQL MVP)" wrote:
> > Hi
> >
> > 1222 = "Lock request time out period exceeded."
> >
> > Run profiler and see what is happening on your server during the loads.
> >
> > Regards
> > --
> > Mike Epprecht, Microsoft SQL Server MVP
> > Zurich, Switzerland
> >
> > MVP Program: http://www.microsoft.com/mvp
> >
> > Blog: http://www.msmvps.com/epprecht/
> >
> >
> >
> > "Stefan W" wrote:
> >
> > > We'w got major performance problems with inserting data into large tables
> > > (more than 25 000 000 rows) after installing the latest sp. The performance
> > > decreased with more than 90%.
> > >
> > > Our program takes one row at the time and creates inserts and updates for
> > > aproximatly 7 tables out of this. Everyr read row is encapsuled in an
> > > transaction.
> > >
> > >
> > > occassionaly we can capture an error during insert. The error is 1222.
> > >
> > >
> > > Have anybody encounted the same problem an even got any solution.
> > >
> > > Thanks|||Hi
Massimo, have you raised a case with Microsoft PSS? If not, you should.
There have been a few posts on performance issues, and they had mostly to do
with a change in the way data type precedence is handled in SP4. I have 78
servers that are on SP4 with 2040 hotfix and none exhibit performance
problems.
Looks to be very application specific.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Massimo" <Massimo@.discussions.microsoft.com> wrote in message
news:640255E5-1885-4210-B9A1-32641D9C17A6@.microsoft.com...
>I will suggest to roll back to SP3a.
> We have have many problems with SP4 as many other people; check other
> posts
> related to SP4 and you will follow my advice.
> Cheers, Massimo
> --
> Software Engineer
> TCF - Amsterdam (NL)
>
> "Stefan W" wrote:
>> Hi!
>> I've tried to do that, but i cant get information from the particular
>> job.
>> The job is desiged as a stored procedure that contains a loop that calls
>> other stored procedures. Iv'e tried using the different templates
>> provided in
>> the profiler but a don't se any of the underlying procedurecalls made in
>> this
>> job. Do you have any suggestions on how to set up the profiler to get
>> hand on
>> these jobs!
>>
>>
>> "Mike Epprecht (SQL MVP)" wrote:
>> > Hi
>> >
>> > 1222 = "Lock request time out period exceeded."
>> >
>> > Run profiler and see what is happening on your server during the loads.
>> >
>> > Regards
>> > --
>> > Mike Epprecht, Microsoft SQL Server MVP
>> > Zurich, Switzerland
>> >
>> > MVP Program: http://www.microsoft.com/mvp
>> >
>> > Blog: http://www.msmvps.com/epprecht/
>> >
>> >
>> >
>> > "Stefan W" wrote:
>> >
>> > > We'w got major performance problems with inserting data into large
>> > > tables
>> > > (more than 25 000 000 rows) after installing the latest sp. The
>> > > performance
>> > > decreased with more than 90%.
>> > >
>> > > Our program takes one row at the time and creates inserts and updates
>> > > for
>> > > aproximatly 7 tables out of this. Everyr read row is encapsuled in an
>> > > transaction.
>> > >
>> > >
>> > > occassionaly we can capture an error during insert. The error is
>> > > 1222.
>> > >
>> > >
>> > > Have anybody encounted the same problem an even got any solution.
>> > >
>> > > Thanks
Subscribe to:
Posts (Atom)