Showing posts with label logs. Show all posts
Showing posts with label logs. Show all posts

Sunday, March 11, 2012

Conditional row count

Hi,

Is there a way to to use RowCount based on a condition?

I have AS400 logs in csv file which I want to append to a SQL table using filters. But during passing of each record, I also want to count row only if they matches to a specific criteria.

Thanks

Use a conditional split transformation to look at your data. Then on which ever output you desire, use a row counter. A row counter isn't a destination (it can be though), so it can go in-line with your flow.

Sunday, February 19, 2012

concurrent query limit

i am getting this message in the SQL server logs. But i dont know where to
make the changes to increase the limit...
"This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected."
thanks
You are running either MSDE or Personal Edition. These has a performance throttling mechanism that you have
hit. Evaluate whether you want to install a "proper" SQL Server (Standard or Enterprise edition).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"harun" <kazi[remove]@.wideopenwest.com> wrote in message news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "This SQL Server has been optimized for 8 concurrent queries. This limit has
> been exceeded by 1 queries and performance may be adversely affected."
> thanks
>
|||Hi
This may help if you are using MSDE
http://msdn.microsoft.com/library/de...r_sa2_5fs6.asp
John
"harun" <kazi[remove]@.wideopenwest.com> wrote in message
news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected."
> thanks
>
|||Folks--
Has anyone gotten this message when they have installed SQL Server Standard
Edition ? I installed Standard Edition from original media purchased from
CDW, and am now seeing this error message very frequently in the Event Viewer
logs.
"John Bell" wrote:

> Hi
> This may help if you are using MSDE
> http://msdn.microsoft.com/library/de...r_sa2_5fs6.asp
> John
> "harun" <kazi[remove]@.wideopenwest.com> wrote in message
> news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> has
>
>
|||My guess is that you have two instances or more of SQL Server and an MSDE instance is giving you the
messages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mxnova" <mxnova@.discussions.microsoft.com> wrote in message
news:AE404F97-2F1B-4F73-9C3B-A322A6E24677@.microsoft.com...[vbcol=seagreen]
> Folks--
> Has anyone gotten this message when they have installed SQL Server Standard
> Edition ? I installed Standard Edition from original media purchased from
> CDW, and am now seeing this error message very frequently in the Event Viewer
> logs.
>
> "John Bell" wrote:

concurrent query limit

i am getting this message in the SQL server logs. But i dont know where to
make the changes to increase the limit...
"This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected."
thanksYou are running either MSDE or Personal Edition. These has a performance thr
ottling mechanism that you have
hit. Evaluate whether you want to install a "proper" SQL Server (Standard or
Enterprise edition).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"harun" <kazi[remove]@.wideopenwest.com> wrote in message news:ea4O43tUEHA.1604@.TK2MSFTNG
P12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "This SQL Server has been optimized for 8 concurrent queries. This limit h
as
> been exceeded by 1 queries and performance may be adversely affected."
> thanks
>|||Hi
This may help if you are using MSDE
_5fs6.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
_5fs6.asp
John
"harun" <kazi[remove]@.wideopenwest.com> wrote in message
news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected."
> thanks
>|||Folks--
Has anyone gotten this message when they have installed SQL Server Standard
Edition ? I installed Standard Edition from original media purchased from
CDW, and am now seeing this error message very frequently in the Event Viewe
r
logs.
"John Bell" wrote:

> Hi
> This may help if you are using MSDE
> a2_5fs6.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
a2_5fs6.asp
> John
> "harun" <kazi[remove]@.wideopenwest.com> wrote in message
> news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> has
>
>|||My guess is that you have two instances or more of SQL Server and an MSDE in
stance is giving you the
messages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mxnova" <mxnova@.discussions.microsoft.com> wrote in message
news:AE404F97-2F1B-4F73-9C3B-A322A6E24677@.microsoft.com...[vbcol=seagreen]
> Folks--
> Has anyone gotten this message when they have installed SQL Server Standar
d
> Edition ? I installed Standard Edition from original media purchased from
> CDW, and am now seeing this error message very frequently in the Event Vie
wer
> logs.
>
> "John Bell" wrote:
>

concurrent query limit

i am getting this message in the SQL server logs. But i dont know where to
make the changes to increase the limit...
"This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected."
thanksYou are running either MSDE or Personal Edition. These has a performance throttling mechanism that you have
hit. Evaluate whether you want to install a "proper" SQL Server (Standard or Enterprise edition).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"harun" <kazi[remove]@.wideopenwest.com> wrote in message news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "This SQL Server has been optimized for 8 concurrent queries. This limit has
> been exceeded by 1 queries and performance may be adversely affected."
> thanks
>|||From BOL:
"SQL Server 2000 Desktop Engine and SQL Server 2000
Personal Edition have a concurrent workload governor that
limits performance when more than eight operations are run
concurrently". Have a look at DBCC CONCURRENCYVIOLATION to
get more info, but as far as I understand this limit is
not configurable (unless you upgrade to another edition of
course).
HTH,
Paul Ibison|||Hi
This may help if you are using MSDE
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_5fs6.asp
John
"harun" <kazi[remove]@.wideopenwest.com> wrote in message
news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected."
> thanks
>|||My guess is that you have two instances or more of SQL Server and an MSDE instance is giving you the
messages.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mxnova" <mxnova@.discussions.microsoft.com> wrote in message
news:AE404F97-2F1B-4F73-9C3B-A322A6E24677@.microsoft.com...
> Folks--
> Has anyone gotten this message when they have installed SQL Server Standard
> Edition ? I installed Standard Edition from original media purchased from
> CDW, and am now seeing this error message very frequently in the Event Viewer
> logs.
>
> "John Bell" wrote:
> > Hi
> >
> > This may help if you are using MSDE
> >
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_5fs6.asp
> >
> > John
> > "harun" <kazi[remove]@.wideopenwest.com> wrote in message
> > news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> > > i am getting this message in the SQL server logs. But i dont know where to
> > > make the changes to increase the limit...
> > >
> > > "This SQL Server has been optimized for 8 concurrent queries. This limit
> > has
> > > been exceeded by 1 queries and performance may be adversely affected."
> > >
> > > thanks
> > >
> > >
> >
> >
> >