Jun 05 2012

Guest Blog

I was given the opportunity to put together a guest blog post for the MVP blog. I did a little something on determining whether or not you have high memory use through the use of a DMO. Check it out.

5 Comments

  • By JohnW, June 5, 2012 @ 9:15 pm

    Grant, I posted this on the MVP blog, but it seems to be pending moderation; on the first query, I get an error stating that ‘Arithmetic overflow error converting expression to data type int; haven’t figured it out yet.

    I can run the CTE alone and get ~30 records, with the largest timestamp of 1721618323. Target system is 2008 R2 x64 with SP0 CU8 64 GB memory.

    As a side note, AWE can be nonzero on 64 bit systems if Lock Pages In Memory is enabled; while the need for that is reduced, it is not yet eliminated.

  • By Grant Fritchey, June 6, 2012 @ 6:13 am

    I’m assuming by first query you don’t mean the SELECT * one. We’d have to be talking about the date conversion. It’s not necessary for the query itself. That bit of code I picked up off the MSDN forums. It worked very consistently on everything I tested it on & I’ve seen it used by multiple others. Maybe try substituting SYSDATETIME for GETDATE.

  • By JohnW, June 6, 2012 @ 8:19 am

    Grant, that was it. I borrowed a line from a similar post I saw later in the day from sqlskills and get the correct results.

    DATEADD(ms, (-1 * ((dosi.cpu_ticks / CONVERT ( float,(dosi.cpu_ticks / dosi.ms_ticks)))
    – rb.timestamp)), GETDATE()) AS RmDateTime

  • By Brian, August 20, 2012 @ 1:32 pm

    Hi,

    I ran across your site, and really appreciate the content. I run a dba website and I am always seeking opportunities to write some guest blog posts for quality sites such as yours. Would you be interested? I have a variety of content, but if you have something specific that you want to focus on for your readers, I would be glad to write something up. If this is of interest to you, please get back with me.

    Regards,


    Brian Hines | Online Marketing Specialist
    TheDBAShoppe.com | Remote Database Administration

  • By Grant Fritchey, August 20, 2012 @ 2:34 pm

    Thanks for the interest, but I’m pretty much a one-man show here. However, if you’re interested in writing opportunities, I’d suggest SQL Server Central.com or Simple-Talk.com. They are both always needful of good articles.

Other Links to this Post

RSS feed for comments on this post. TrackBack URI

Leave a comment