Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

  • RE: Having a SQL 2008 R2 Database in Memory

    GilaMonster (11/6/2012)

    rmudway (11/6/2012)

    GilaMonster (11/5/2012)

    Doesn't sound right. If the historical data isn't queried, it won;t be in memory, doesn't matter if in one DB or two.

    Well... i dont need the historical...

    November 6, 2012 at 7:36 pm

    #1556620

  • RE: Having a SQL 2008 R2 Database in Memory

    Koen Verbeeck (11/6/2012)

    rmudway (11/6/2012)

    Did anyone see my question earlier?

    Yes. Gail already replied to that.

    Actually, im still hoping for a response on this, as Gail kindly answered the question before :pinch:

    November 6, 2012 at 1:13 am

    #1556343

  • RE: Having a SQL 2008 R2 Database in Memory

    Koen Verbeeck (11/6/2012)

    rmudway (11/6/2012)

    sanket kokane (11/6/2012)

    in your this case you don't need /PAE option ..as you are using 64 bit machine

    I hear you on that one and not like that...

    November 6, 2012 at 12:59 am

    #1556338

  • RE: Having a SQL 2008 R2 Database in Memory

    sanket kokane (11/6/2012)

    in your this case you don't need /PAE option ..as you are using 64 bit machine

    I hear you on that one and not like that option/switch very much.

    There...

    November 6, 2012 at 12:48 am

    #1556335

  • RE: Having a SQL 2008 R2 Database in Memory

    sanket kokane (11/5/2012)

    GilaMonster (11/5/2012)

    sanket kokane (11/5/2012)

    What I was mean to say is consider enabling /PAE as your last option.

    If running SQL on 32-bit OS with more than 4GB of memory,...

    November 6, 2012 at 12:12 am

    #1556323

  • RE: Having a SQL 2008 R2 Database in Memory

    GilaMonster (11/5/2012)

    Doesn't sound right. If the historical data isn't queried, it won;t be in memory, doesn't matter if in one DB or two.

    Well... i dont need the historical data too...

    November 6, 2012 at 12:09 am

    #1556321

  • RE: Having a SQL 2008 R2 Database in Memory

    I also had some advice from someone who said that for me to get over a performance issue with my Database, i could use a 2nd Database which would have...

    November 5, 2012 at 9:11 pm

    #1556284

  • RE: Having a SQL 2008 R2 Database in Memory

    Koen Verbeeck (11/5/2012)

    sanket kokane (11/5/2012)

    Also consider this as your very last options.

    To speed up your DB check,first check if there any scope for Query Tuning.

    I wouldn't consider this the...

    November 5, 2012 at 8:59 pm

    #1556278

  • RE: Having a SQL 2008 R2 Database in Memory

    Hi sanket,

    The Machine is 64-bit, so i have not done this setting.

    The OS is Win 2008 R2 Ent and my Database is running on SQL 2008 R2 STD.

    Thanks.

    November 5, 2012 at 8:01 pm

    #1556273

  • RE: Having a SQL 2008 R2 Database in Memory

    Hi sanket!!

    Thanks for your response, that was a nice little piece of info. I found that my test machine had the whole DB in RAM, but the Main SQL Server...

    November 5, 2012 at 6:20 am

    #1556014

  • RE: Empty Stored Proc takes 8ms to complete?

    Hi,

    Thanks for the Stored Proc code with the Statistics option.

    While i was running some tests i eventually needed to time how long the Stored Proc was taking inside SQL, so...

    February 15, 2010 at 2:19 am

    #1118703

Viewing 11 posts - 1 through 11 (of 11 total)