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
  2. FrankKalis Moderator

    If not for performance reasons, I would choose some other prefix just to distinguish user objects from system objects.
  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
  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...? [:)]

Share This Page