SQL Server Performance

performance query.....

Discussion in 'SQL Server 2008 T-SQL Performance Tuning' started by srimkumarp, Mar 17, 2009.

  1. srimkumarp New Member

    Hi All,

    can any one please explain me if user stored procedures and user defined funtions is having prefix sp_userprocedures; and fn_userfuntions.

    Like this your developers are created so many for so many user sp and user functions databases;will it be decrease the performance of the database

    thanks, kumar
    srimkumarp, Mar 17, 2009
    #2

  2. FrankKalis Moderator

    If not for performance reasons, I would choose some other prefix just to distinguish user objects from system objects.
    FrankKalis, Mar 18, 2009
    #3

  3. srimkumarp New Member

    hi,
    i am pulling standard reports from server. when ever i've pull it shows for some user function,user procedure.
    for example fn_reports is taking cpu time 81,835,928 ms.
    It is causing slowness from application point of view....
    please suggest
    srimkumarp, Mar 18, 2009
    #4

  4. FrankKalis Moderator

    [quote user="srimkumarp"]
    i am pulling standard reports from server. when ever i've pull it shows for some user function,user procedure.
    for example fn_reports is taking cpu time 81,835,928 ms.
    It is causing slowness from application point of view....
    please suggest
    [/quote]
    ...without seeing any code and more information about tables, data volume, etc...? [:)]
    FrankKalis, Mar 18, 2009
    #5

Share This Page