Re: high Compilations/sec value

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bhanu (SQLDBA1999_at_yahoo.com)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 16:53:49 -0400

If you have create SPs that are frequently used, with recompile option might
bring up compilations/sec high.

"mm" <postto@news.com> wrote in message
news:u1p$2asuEHA.452@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> Would someone please explain what causes a high "Compilations/sec" count?
>
> Is still caued by stored procedures not being cached and not enough memory
> alloacted to SQL Server.
>
>
> Thanks
>
>
>

Relevant Pages

  • Re: how to rollback a procedure (sqlserver) from VB2005?
    ... Maybe it is because I am simplifying some of the stored procedures (that I ... app than the whole procedure in sqlserver. ... running sql inline in the app. ... structure I could use to store the SPs in a more orderly fashion? ...
    (microsoft.public.dotnet.languages.vb)
  • Embedded Stored Procedure within App
    ... We have an application with is store procedure dependent. ... way to simplify our deployment by embedding Stored Procedures within our ... application so that we do not have to "keep track" of which SPs to promote. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Embedded Stored Procedure within App
    ... We have an application with is store procedure dependent. ... way to simplify our deployment by embedding Stored Procedures within our ... application so that we do not have to "keep track" of which SPs to promote. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Identity Column
    ... Especially when proper error handling tells me which stored procedure ... So you're saying if I use stored procedures I can't refactor, ... SPs. ... So genius, how exactly would you refactor, use source control, or do ...
    (microsoft.public.sqlserver.programming)
  • Re: How are stored procedures stored in SQL?
    ... I'm guessing you want the total amount of lines for all SPs. ... >> A lot of our application logic lives in stored procedures. ...
    (microsoft.public.sqlserver.programming)