Post reply

Timing Issue

  • December 9, 2013 at 5:23 am

    #1671897

    Code please (and maybe use people's names not their forum status?)

    SQL won't skip lines in a procedure so there's something odd going on, possibly stuff failing silently.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 10, 2013 at 6:12 am

    #1672283

    Sorry about that. I was looking in the wrong places - when it comes to names.

  • December 10, 2013 at 8:35 am

    #1672344

    One of the things that I have noticed is that when all SPs were working as expected, sqlsrvr.exe would take over 5gb of memory under running processes in task manager. But now it has only been using less than 1 gb and only after several hours of me running processing it takes up more memory.

    Thanks,

    Tina

  • December 10, 2013 at 8:38 am

    #1672346

    tinausa (12/10/2013)

    One of the things that I have noticed is that when all SPs were working as expected, sqlsrvr.exe would take over 5gb of memory under running processes in task manager. But now it has only been using less than 1 gb and only after several hours of me running processing it takes up more memory.

    Thanks,

    Tina

    Have you restricted max server memory? chack that in sp_configure. SQL Server will take the whole memory anyway.

    Igor Micev,My blog: www.igormicev.com

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply