<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: BL680G7 MS SQL Server 2008 R2 performance issues in BladeSystem - General</title>
    <link>https://community.hpe.com/t5/bladesystem-general/bl680g7-ms-sql-server-2008-r2-performance-issues/m-p/5514141#M28602</link>
    <description>&lt;P&gt;Hi Danil,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Please check this link:&lt;/P&gt;&lt;P&gt;&lt;A target="_blank" href="http://books.google.com/books?id=6VcwMpLhjVAC&amp;amp;pg=PT201&amp;amp;lpg=PT201&amp;amp;dq=memory_node_id&amp;amp;source=bl&amp;amp;ots=BZ8OSe0WGl&amp;amp;sig=j2YGoz0LdqVkDb6WX4CT-c57xiQ&amp;amp;hl=en&amp;amp;sa=X&amp;amp;ei=67AnT469BIjg2AXGiKXoAg&amp;amp;ved=0CEMQ6AEwBQ#v=onepage&amp;amp;q=memory_node_id&amp;amp;f=false"&gt;http://books.google.com/books?id=6VcwMpLhjVAC&amp;amp;pg=PT201&amp;amp;lpg=PT201&amp;amp;dq=memory_node_id&amp;amp;source=bl&amp;amp;ots=BZ8OSe0WGl&amp;amp;sig=j2YGoz0LdqVkDb6WX4CT-c57xiQ&amp;amp;hl=en&amp;amp;sa=X&amp;amp;ei=67AnT469BIjg2AXGiKXoAg&amp;amp;ved=0CEMQ6AEwBQ#v=onepage&amp;amp;q=memory_node_id&amp;amp;f=false&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;HTH,&lt;/P&gt;&lt;P&gt;Surendar&lt;/P&gt;&lt;DIV&gt;How to assign &lt;FONT face="arial black,avant garde"&gt;&lt;STRONG&gt;&lt;FONT color="#0000ff"&gt;KUDOS!&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/FONT&gt; Click the &lt;FONT color="#0000ff" face="arial black,avant garde"&gt;STAR!&lt;/FONT&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;P&gt;&lt;STRONG&gt;&lt;FONT size="1"&gt;HP Guided Troubleshooting - &lt;A target="_blank" rel="nofollow" href="http://www.hp.com/support/hpgt"&gt;www.hp.com/support/hpgt&lt;/A&gt;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 31 Jan 2012 09:17:43 GMT</pubDate>
    <dc:creator>S_Logan</dc:creator>
    <dc:date>2012-01-31T09:17:43Z</dc:date>
    <item>
      <title>BL680G7 MS SQL Server 2008 R2 performance issues</title>
      <link>https://community.hpe.com/t5/bladesystem-general/bl680g7-ms-sql-server-2008-r2-performance-issues/m-p/5495963#M28601</link>
      <description>&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I&amp;nbsp;have HP BL680G7 server and windows server 2008 R2, SQL Server 2008 R2 installed on it.&lt;/P&gt;&lt;P&gt;We migrated our DB from bl460G1( with &amp;nbsp;windows server 2003 and sql server 2005 on it ) to BL680G7 with windows server 2008 R2 and SQL Server 2008 R2 and we have not seen peformance growth also&amp;nbsp; a little decrease.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I think that performance issues &lt;SPAN class="hps trans-target"&gt;related to SQL Server &amp;nbsp;numa &lt;SPAN class="short_text"&gt;&lt;SPAN class="hps"&gt;settings.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;SELECT DISTINCT memory_node_id&lt;/P&gt;&lt;P&gt;FROM sys.dm_os_memory_clerks&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;memory_node_id&lt;BR /&gt;1&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 0&lt;BR /&gt;2&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 3&lt;BR /&gt;3&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 64&lt;BR /&gt;4&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 1&lt;BR /&gt;5&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;2&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Does server has correct settings for numa hardware support?&lt;/P&gt;</description>
      <pubDate>Mon, 16 Jan 2012 08:08:14 GMT</pubDate>
      <guid>https://community.hpe.com/t5/bladesystem-general/bl680g7-ms-sql-server-2008-r2-performance-issues/m-p/5495963#M28601</guid>
      <dc:creator>IS.Danil</dc:creator>
      <dc:date>2012-01-16T08:08:14Z</dc:date>
    </item>
    <item>
      <title>Re: BL680G7 MS SQL Server 2008 R2 performance issues</title>
      <link>https://community.hpe.com/t5/bladesystem-general/bl680g7-ms-sql-server-2008-r2-performance-issues/m-p/5514141#M28602</link>
      <description>&lt;P&gt;Hi Danil,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Please check this link:&lt;/P&gt;&lt;P&gt;&lt;A target="_blank" href="http://books.google.com/books?id=6VcwMpLhjVAC&amp;amp;pg=PT201&amp;amp;lpg=PT201&amp;amp;dq=memory_node_id&amp;amp;source=bl&amp;amp;ots=BZ8OSe0WGl&amp;amp;sig=j2YGoz0LdqVkDb6WX4CT-c57xiQ&amp;amp;hl=en&amp;amp;sa=X&amp;amp;ei=67AnT469BIjg2AXGiKXoAg&amp;amp;ved=0CEMQ6AEwBQ#v=onepage&amp;amp;q=memory_node_id&amp;amp;f=false"&gt;http://books.google.com/books?id=6VcwMpLhjVAC&amp;amp;pg=PT201&amp;amp;lpg=PT201&amp;amp;dq=memory_node_id&amp;amp;source=bl&amp;amp;ots=BZ8OSe0WGl&amp;amp;sig=j2YGoz0LdqVkDb6WX4CT-c57xiQ&amp;amp;hl=en&amp;amp;sa=X&amp;amp;ei=67AnT469BIjg2AXGiKXoAg&amp;amp;ved=0CEMQ6AEwBQ#v=onepage&amp;amp;q=memory_node_id&amp;amp;f=false&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;HTH,&lt;/P&gt;&lt;P&gt;Surendar&lt;/P&gt;&lt;DIV&gt;How to assign &lt;FONT face="arial black,avant garde"&gt;&lt;STRONG&gt;&lt;FONT color="#0000ff"&gt;KUDOS!&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/FONT&gt; Click the &lt;FONT color="#0000ff" face="arial black,avant garde"&gt;STAR!&lt;/FONT&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;P&gt;&lt;STRONG&gt;&lt;FONT size="1"&gt;HP Guided Troubleshooting - &lt;A target="_blank" rel="nofollow" href="http://www.hp.com/support/hpgt"&gt;www.hp.com/support/hpgt&lt;/A&gt;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 31 Jan 2012 09:17:43 GMT</pubDate>
      <guid>https://community.hpe.com/t5/bladesystem-general/bl680g7-ms-sql-server-2008-r2-performance-issues/m-p/5514141#M28602</guid>
      <dc:creator>S_Logan</dc:creator>
      <dc:date>2012-01-31T09:17:43Z</dc:date>
    </item>
  </channel>
</rss>

