Derek Czarny

My feedback

  1. 3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Derek Czarny supported this idea  · 
  2. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Have you always used SSMS to configure your system? I.e. not other tools or straight T-SQL? Is it a coincidence that for both columns you have a value of 14420? Is that a value you recall explicitly setting?

    From what you are telling me, it looks like SSMS is assuming that 14420 is a number of days (as opposed to a number of minutes), hence it can’t handle it because “it is too big”).

    More investigation going on…

    Thanks,
    -Matteo

    Derek Czarny commented  · 

    No, it was done using T-SQL. I was just trying to go in and look at something in the setup when it crashed.

    Derek Czarny commented  · 

    14420 - Threshold_alert
    14420 - history_retention_period

    Derek Czarny commented  · 

    I was waiting for 18GA to come out. I didn't even have any of the previews installed on this computer.

    SQL Server Management Studio 15.0.18118.0
    Microsoft Analysis Services Client Tools 15.0.1300.131
    Microsoft Data Access Components (MDAC) 10.0.17134.1
    Microsoft MSXML 3.0 6.0
    Microsoft Internet Explorer 9.11.17134.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 6.3.17134

    Derek Czarny commented  · 

    https://1drv.ms/u/s!AidvjdUUZeNaiLUBFyqd2fdWk4ZXbQ

    Here is a link to the procdump request

    Derek Czarny commented  · 

    I am having trouble uploading the 325mb file it generated.

    Derek Czarny shared this idea  · 
  3. 8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 198

    <=-=Nov 3 2015 10:21AM=-=>

    And not just for sandboxing…on production servers where we have special crazy-fast multi-TB cache cards for the TempDB but the SAN where the production databases reside is relatively slow. This makes it very compelling to force a lot of things to happen inside TempDB and then later sync that to production.

    <=-=Apr 2 2017 8:08AM=-=>

    Thank you for taking time to post this issue! We understand that this could be an important issue for you.

    This item is high on our priory list, but unfortunately, we do not plan to include a fix for this issue in the upcoming release. Although, we might include it as an improvement in future releases.

    <=-=Apr 2 2017 8:08AM=-=>

    Thank you for taking time to post this issue! We understand that this could be an important issue for you.

    This item is high on our priory list, but…

    Derek Czarny supported this idea  · 
  4. 6 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Derek Czarny supported this idea  · 
  5. 20 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 3

    <=-=May 27 2017 6:38AM=-=>

    Thank you for taking the time to post this issue! We understand that this could be an important performance improvement.
    Performance tuning is of such scenarios is not a trivial task. Change of such feature as Query Store can speed up one scenario and lead to degradation in others. We�ll look more into this particular use case and see what we can do.

    Derek Czarny supported this idea  · 
  6. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Derek Czarny supported this idea  · 
  7. 93 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Derek Czarny supported this idea  · 
  8. 126 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  4 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Derek Czarny supported this idea  · 

Feedback and Knowledge Base