Fush IDES

In sql profiler I see the following ObjectName called "Flush IDES". It
appears to occur after a commit of a user_transaction? It's
EventSubClass is all "0-begin" and "1-commit"s?
Does anybody know what this is?
My guess this is what you may see.
IDESThe IDES latch waitresource is used when the PFS page is scanned to
find free space and when the PFS page is updated to reflect allocations and
deallocations of pages. This latch is also used when single pages are
allocated to an existing object.Determine whether you have a clustered index
on the object in question.
reference.
http://support.microsoft.com/kb/822101/en-us
this is applicable to sql 200 sp4 and later versions.
You did not provide all the info from the trace to say for sure. So it is a
guess.
Thanks, Liliya
"Ken" wrote:

> In sql profiler I see the following ObjectName called "Flush IDES". It
> appears to occur after a commit of a user_transaction? It's
> EventSubClass is all "0-begin" and "1-commit"s?
> Does anybody know what this is?
>
sql

Fush IDES

In sql profiler I see the following ObjectName called "Flush IDES". It
appears to occur after a commit of a user_transaction? It's
EventSubClass is all "0-begin" and "1-commit"s?
Does anybody know what this is?My guess this is what you may see.
IDES The IDES latch waitresource is used when the PFS page is scanned to
find free space and when the PFS page is updated to reflect allocations and
deallocations of pages. This latch is also used when single pages are
allocated to an existing object. Determine whether you have a clustered index
on the object in question.
reference.
http://support.microsoft.com/kb/822101/en-us
this is applicable to sql 200 sp4 and later versions.
You did not provide all the info from the trace to say for sure. So it is a
guess.
--
Thanks, Liliya
"Ken" wrote:
> In sql profiler I see the following ObjectName called "Flush IDES". It
> appears to occur after a commit of a user_transaction? It's
> EventSubClass is all "0-begin" and "1-commit"s?
> Does anybody know what this is?
>

Function Compiling Error 2005(2153)

Hello!

I have scalar function which calls from stored procedure. When SP recompiling (before start) in profiler I see Exception "Error: 536, Severity: 16, State: 5" - Invalid length parameter passed to the SUBSTRING function. at next line of function (original text changed for easy sample) :

if @.p1=4 set @.s1=substring(@.ipstr,1,@.p1-1)

but at same line like:

if @.p1=4 set @.s1=substring(@.ipstr,1,3)

works good.

Somebody can explain such?

I think you should proivide full repro with variables declaration and initialization.

Don't forget to mention MSSQL version you run this script on.

Function (fn locate(@p1, P_fam_nm))

In the profiler, I saw the following constructions as part of a statement :
(fn locate(@.p1, P_fam_nm))= 1
This look to me as an ODBC function, but I cannot find the function
described in the BOL. The function is problably replaced by a SQL-server
function. (Could be patindex).
Where and how can I find which function is used in SQL-server instead.
Or can SQL-server run this type (ODBC ?) functions ?
ben brugmanI've never heard of that function. I googled it and didn't see any hits
associated with ODBC or MDAC. It doesn't exist on my server. So... I suspect
it's a user defined function.
You can run this statement in all your databases to see where the function
exists.
select * from sysobjects where name like 'fn_locate'
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"ben brugman" <ben@.niethier.nl> wrote in message
news:ebZVBx1sDHA.2508@.TK2MSFTNGP12.phx.gbl...
> In the profiler, I saw the following constructions as part of a statement
:
> (fn locate(@.p1, P_fam_nm))= 1
> This look to me as an ODBC function, but I cannot find the function
> described in the BOL. The function is problably replaced by a SQL-server
> function. (Could be patindex).
> Where and how can I find which function is used in SQL-server instead.
> Or can SQL-server run this type (ODBC ?) functions ?
> ben brugman
>|||I see in in the profiler, the coding using it, does work.
The syntax is <(FN locate(string1,string2))
The FN denotes the a function follows.
Behind the FN is a space.
If it is a user defined function the calling program
does define the function before it is called, because
it is not inserted by 'humans'.
And the function does not work from the QA so it
is not present as such.
I'll have a check if the calling program is defining the
function, but this is unlikely to me.
(The workings of the function is very similar (or equal to)
patindex).
ben brugman
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:ucz3LR2sDHA.3492@.TK2MSFTNGP11.phx.gbl...
> I've never heard of that function. I googled it and didn't see any hits
> associated with ODBC or MDAC. It doesn't exist on my server. So... I
suspect
> it's a user defined function.
> You can run this statement in all your databases to see where the function
> exists.
> select * from sysobjects where name like 'fn_locate'
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "ben brugman" <ben@.niethier.nl> wrote in message
> news:ebZVBx1sDHA.2508@.TK2MSFTNGP12.phx.gbl...
> > In the profiler, I saw the following constructions as part of a
statement
> :
> >
> > (fn locate(@.p1, P_fam_nm))= 1
> >
> > This look to me as an ODBC function, but I cannot find the function
> > described in the BOL. The function is problably replaced by a SQL-server
> > function. (Could be patindex).
> >
> > Where and how can I find which function is used in SQL-server instead.
> > Or can SQL-server run this type (ODBC ?) functions ?
> >
> > ben brugman
> >
> >
>