Re: [mssms] RE: Slow Console performance for some users

2017-09-29 Thread Stuart Watret 
Awesome info everyone, and a reminder why I love this list so much. It’s a 
disappointing state of affairs if it turns out to be this. The call is in, 
hopefully they will reach the same conclusion or it’s something else.
I’ll update the thread when I get a resolution.

Stuart

Sent from a dog and bone.
_
From: Sherry Kissinger 
<sherrylkissin...@gmail.com<mailto:sherrylkissin...@gmail.com>>
Sent: Thursday, September 28, 2017 20:59r
Subject: Re: [mssms] RE: Slow Console performance for some users
To: <mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>>


oh, by the way... SQL 2016 SP1 CU5... we're still on CU5 just in the lab.  
We're on CU2 in production.  CU3 Microsoft said "don't do it".  CU4 we tried... 
and we got sql replication delays and issues with DRS.  uninstalled CU4 and 
everything was fine.  (but apparently we're the only ones that reported that 
issue).  We haven't put CU5 in production yet.  So... that said... "just in 
case" you think it MIGHT be the CU5; if you're going to try to downgrade to a 
different CU; downgrade to CU2.  CU5 might be fine, tho.

On Thu, Sep 28, 2017 at 2:49 PM, Sherry Kissinger 
<sherrylkissin...@gmail.com<mailto:sherrylkissin...@gmail.com>> wrote:
We've seen sporadic Console slowness issues, "usually" seen when we have 
Compatibility set to SQL 2016, and the person using the console is not a 'full 
admin'.  If we just for the cm_ database at the CAS (yes, we sadly need a cas, 
with over 300k clients, we have to have one.  :( ) , set it to sql 2012 (not 
sql 2014, fyi, but that's just because we've never tested that), and BAM! 
console slowness issues gone.

We've tried various things with various success rates.  One team member spent 
WEEKS running, re-running, tweaking, adjusting, etc. etc. the Ola Hallengren 
indexing scripts, and adjusting the timings, and trying more frequent update 
statistics.  sometimes it would help... and then a day or two would pass, and 
although nothing had changed and the reindexing/statistics had run just fine; 
console slowness again.  So again... back to sql 2012 compatibility.  We keep 
trying, though.

But honestly it's not like we spend every waking moment trying to get to sql 
2016 compatibility.  It would be nice to have it; but since we can work around 
the issue by bumping the CAS (and this is just the cas, we leave the primaries 
at sql 2016 compat), down to sql 2012, we just live with it until we get a 
spare moment to try again.

On Thu, Sep 28, 2017 at 2:13 PM, Jason Sandys 
<ja...@sandys.us<mailto:ja...@sandys.us>> wrote:
The slowdown is a result of RBA processing. The more complicated the RBA rules, 
the more noticeable the slowdown. No RBA = no slowdown.

I think that article may have a typo in it.

Changing the compatibility level is easy to do, easy to test, and easily 
reversed.

J

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>]On
 Behalf Of Stuart Watret
Sent: Thursday, September 28, 2017 11:42 AM

To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [mssms] RE: Slow Console performance for some users

for me it doesn’t explain the fact some people are fine, ill open a call 
tomorrow.

On 28 Sep 2017, at 17:26, Daniel Ratliff 
<dratl...@humana.com<mailto:dratl...@humana.com>> wrote:

Its recommended to be set to 130 per the article yes, but that doesn’t mean you 
don’t have the issue.

Find a culprit query, and run the instructions they gave to see if you are 
impacted.

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff
Sent: Thursday, September 28, 2017 12:03 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: Slow Console performance for some users

Heres the details. 
https://support.microsoft.com/en-us/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-d

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Kent, Mark
Sent: Thursday, September 28, 2017 11:38 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: Slow Console performance for some users

We are running SQL2016 as well, the compatibility is set to 2016.  So you are 
recommending dropping this down to 2012?  Does this help address anything else? 
 Just curious, thank you!

Mark Kent
Manager, Client Systems Engineering
Technology Support Services
Resources for Information, Technology and Education (RITE)
http://rite.buffalostate.edu<http://rite.buffalostate.edu/>

From: listsad...@lists.myitforum.com<mailto:listsad...@

Re: [mssms] RE: Slow Console performance for some users

2017-09-28 Thread Sherry Kissinger 
oh, by the way... SQL 2016 SP1 CU5... we're still on CU5 just in the lab.
We're on CU2 in production.  CU3 Microsoft said "don't do it".  CU4 we
tried... and we got sql replication delays and issues with DRS.
uninstalled CU4 and everything was fine.  (but apparently we're the only
ones that reported that issue).  We haven't put CU5 in production yet.
So... that said... "just in case" you think it MIGHT be the CU5; if you're
going to try to downgrade to a different CU; downgrade to CU2.  CU5 might
be fine, tho.

On Thu, Sep 28, 2017 at 2:49 PM, Sherry Kissinger <
sherrylkissin...@gmail.com> wrote:

> We've seen sporadic Console slowness issues, "usually" seen when we have
> Compatibility set to SQL 2016, and the person using the console is not a
> 'full admin'.  If we just for the cm_ database at the CAS (yes, we sadly
> need a cas, with over 300k clients, we have to have one.  :( ) , set it to
> sql 2012 (not sql 2014, fyi, but that's just because we've never tested
> that), and BAM! console slowness issues gone.
>
> We've tried various things with various success rates.  One team member
> spent WEEKS running, re-running, tweaking, adjusting, etc. etc. the Ola
> Hallengren indexing scripts, and adjusting the timings, and trying more
> frequent update statistics.  sometimes it would help... and then a day or
> two would pass, and although nothing had changed and the
> reindexing/statistics had run just fine; console slowness again.  So
> again... back to sql 2012 compatibility.  We keep trying, though.
>
> But honestly it's not like we spend every waking moment trying to get to
> sql 2016 compatibility.  It would be nice to have it; but since we can work
> around the issue by bumping the CAS (and this is just the cas, we leave the
> primaries at sql 2016 compat), down to sql 2012, we just live with it until
> we get a spare moment to try again.
>
> On Thu, Sep 28, 2017 at 2:13 PM, Jason Sandys <ja...@sandys.us> wrote:
>
>> The slowdown is a result of RBA processing. The more complicated the RBA
>> rules, the more noticeable the slowdown. No RBA = no slowdown.
>>
>>
>>
>> I think that article may have a typo in it.
>>
>>
>>
>> Changing the compatibility level is easy to do, easy to test, and easily
>> reversed.
>>
>>
>>
>> J
>>
>>
>>
>> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.myitf
>> orum.com] *On Behalf Of *Stuart Watret
>> *Sent:* Thursday, September 28, 2017 11:42 AM
>>
>> *To:* mssms@lists.myitforum.com
>> *Subject:* Re: [mssms] RE: Slow Console performance for some users
>>
>>
>>
>> for me it doesn’t explain the fact some people are fine, ill open a call
>> tomorrow.
>>
>>
>>
>> On 28 Sep 2017, at 17:26, Daniel Ratliff <dratl...@humana.com> wrote:
>>
>>
>>
>> Its recommended to be set to 130 per the article yes, but that doesn’t
>> mean you don’t have the issue.
>>
>>
>>
>> Find a culprit query, and run the instructions they gave to see if you
>> are impacted.
>>
>>
>>
>> *Daniel Ratliff*
>>
>>
>>
>> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@
>> lists.myitforum.com <listsad...@lists.myitforum.com>] *On Behalf Of *Daniel
>> Ratliff
>> *Sent:* Thursday, September 28, 2017 12:03 PM
>> *To:* mssms@lists.myitforum.com
>> *Subject:* RE: [mssms] RE: Slow Console performance for some users
>>
>>
>>
>> Heres the details. https://support.microsoft.com/en-us/help/3196320/
>> sql-query-times-out-or-console-slow-on-certain-configuration-manager-d
>>
>>
>>
>> *Daniel Ratliff*
>>
>>
>>
>> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@
>> lists.myitforum.com <listsad...@lists.myitforum.com>] *On Behalf Of *Kent,
>> Mark
>> *Sent:* Thursday, September 28, 2017 11:38 AM
>> *To:* mssms@lists.myitforum.com
>> *Subject:* RE: [mssms] RE: Slow Console performance for some users
>>
>>
>>
>> We are running SQL2016 as well, the compatibility is set to 2016.  So you
>> are recommending dropping this down to 2012?  Does this help address
>> anything else?  Just curious, thank you!
>>
>>
>>
>> Mark Kent
>>
>> Manager, Client Systems Engineering
>>
>> Technology Support Services
>>
>> Resources for Information, Technology and Education (RITE)
>>
>> http://rite.buffalostate.edu
>>
>>
>>
>> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@
>> lists.myitforum.com <listsad..

Re: [mssms] RE: Slow Console performance for some users

2017-09-28 Thread Sherry Kissinger 
We've seen sporadic Console slowness issues, "usually" seen when we have
Compatibility set to SQL 2016, and the person using the console is not a
'full admin'.  If we just for the cm_ database at the CAS (yes, we sadly
need a cas, with over 300k clients, we have to have one.  :( ) , set it to
sql 2012 (not sql 2014, fyi, but that's just because we've never tested
that), and BAM! console slowness issues gone.

We've tried various things with various success rates.  One team member
spent WEEKS running, re-running, tweaking, adjusting, etc. etc. the Ola
Hallengren indexing scripts, and adjusting the timings, and trying more
frequent update statistics.  sometimes it would help... and then a day or
two would pass, and although nothing had changed and the
reindexing/statistics had run just fine; console slowness again.  So
again... back to sql 2012 compatibility.  We keep trying, though.

But honestly it's not like we spend every waking moment trying to get to
sql 2016 compatibility.  It would be nice to have it; but since we can work
around the issue by bumping the CAS (and this is just the cas, we leave the
primaries at sql 2016 compat), down to sql 2012, we just live with it until
we get a spare moment to try again.

On Thu, Sep 28, 2017 at 2:13 PM, Jason Sandys <ja...@sandys.us> wrote:

> The slowdown is a result of RBA processing. The more complicated the RBA
> rules, the more noticeable the slowdown. No RBA = no slowdown.
>
>
>
> I think that article may have a typo in it.
>
>
>
> Changing the compatibility level is easy to do, easy to test, and easily
> reversed.
>
>
>
> J
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com] *On Behalf Of *Stuart Watret
> *Sent:* Thursday, September 28, 2017 11:42 AM
>
> *To:* mssms@lists.myitforum.com
> *Subject:* Re: [mssms] RE: Slow Console performance for some users
>
>
>
> for me it doesn’t explain the fact some people are fine, ill open a call
> tomorrow.
>
>
>
> On 28 Sep 2017, at 17:26, Daniel Ratliff <dratl...@humana.com> wrote:
>
>
>
> Its recommended to be set to 130 per the article yes, but that doesn’t
> mean you don’t have the issue.
>
>
>
> Find a culprit query, and run the instructions they gave to see if you are
> impacted.
>
>
>
> *Daniel Ratliff*
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:
> listsad...@lists.myitforum.com <listsad...@lists.myitforum.com>] *On
> Behalf Of *Daniel Ratliff
> *Sent:* Thursday, September 28, 2017 12:03 PM
> *To:* mssms@lists.myitforum.com
> *Subject:* RE: [mssms] RE: Slow Console performance for some users
>
>
>
> Heres the details. https://support.microsoft.com/en-us/help/
> 3196320/sql-query-times-out-or-console-slow-on-certain-
> configuration-manager-d
>
>
>
> *Daniel Ratliff*
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:
> listsad...@lists.myitforum.com <listsad...@lists.myitforum.com>] *On
> Behalf Of *Kent, Mark
> *Sent:* Thursday, September 28, 2017 11:38 AM
> *To:* mssms@lists.myitforum.com
> *Subject:* RE: [mssms] RE: Slow Console performance for some users
>
>
>
> We are running SQL2016 as well, the compatibility is set to 2016.  So you
> are recommending dropping this down to 2012?  Does this help address
> anything else?  Just curious, thank you!
>
>
>
> Mark Kent
>
> Manager, Client Systems Engineering
>
> Technology Support Services
>
> Resources for Information, Technology and Education (RITE)
>
> http://rite.buffalostate.edu
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:
> listsad...@lists.myitforum.com <listsad...@lists.myitforum.com>] *On
> Behalf Of *Jason Sandys
> *Sent:* Thursday, September 28, 2017 10:41 AM
> *To:* mssms@lists.myitforum.com
> *Subject:* RE: [mssms] RE: Slow Console performance for some users
>
>
>
> Change the compatibility level for the ConfigMgr database in SQL Server to
> SQL Server 2012 (110). There is a known issue that stems from a change in
> SQL Server 2014 and 2016 that hasn’t been accounted for (yet to my
> knowledge) in ConfigMgr.
>
>
>
> J
>
>
>
> -Original Message-
>
> From: listsad...@lists.myitforum.com [mailto:
> listsad...@lists.myitforum.com <listsad...@lists.myitforum.com>] On
> Behalf Of Stuart Watret
>
> Sent: Thursday, September 28, 2017 8:42 AM
>
> To: mssms@lists.myitforum.com
>
> Subject: Re: [mssms] RE: Slow Console performance for some users
>
>
>
> What I’m seeing in that log is sql execution delays, the same time his
> console is waiting.
>
>
>
> I do the same thing, navigate to the same package it’s almost instant.
>
>
>
>

RE: [mssms] RE: Slow Console performance for some users

2017-09-28 Thread Jason Sandys 
The slowdown is a result of RBA processing. The more complicated the RBA rules, 
the more noticeable the slowdown. No RBA = no slowdown.

I think that article may have a typo in it.

Changing the compatibility level is easy to do, easy to test, and easily 
reversed.

J

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Stuart Watret
Sent: Thursday, September 28, 2017 11:42 AM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] RE: Slow Console performance for some users

for me it doesn’t explain the fact some people are fine, ill open a call 
tomorrow.

On 28 Sep 2017, at 17:26, Daniel Ratliff 
<dratl...@humana.com<mailto:dratl...@humana.com>> wrote:

Its recommended to be set to 130 per the article yes, but that doesn’t mean you 
don’t have the issue.

Find a culprit query, and run the instructions they gave to see if you are 
impacted.

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff
Sent: Thursday, September 28, 2017 12:03 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: Slow Console performance for some users

Heres the details. 
https://support.microsoft.com/en-us/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-d

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Kent, Mark
Sent: Thursday, September 28, 2017 11:38 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: Slow Console performance for some users

We are running SQL2016 as well, the compatibility is set to 2016.  So you are 
recommending dropping this down to 2012?  Does this help address anything else? 
 Just curious, thank you!

Mark Kent
Manager, Client Systems Engineering
Technology Support Services
Resources for Information, Technology and Education (RITE)
http://rite.buffalostate.edu<http://rite.buffalostate.edu/>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Sandys
Sent: Thursday, September 28, 2017 10:41 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: Slow Console performance for some users

Change the compatibility level for the ConfigMgr database in SQL Server to SQL 
Server 2012 (110). There is a known issue that stems from a change in SQL 
Server 2014 and 2016 that hasn’t been accounted for (yet to my knowledge) in 
ConfigMgr.

J

-Original Message-
From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret
Sent: Thursday, September 28, 2017 8:42 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [mssms] RE: Slow Console performance for some users

What I’m seeing in that log is sql execution delays, the same time his console 
is waiting.

I do the same thing, navigate to the same package it’s almost instant.

I click, I see a sql command and my console refreshes, he clicks, same command, 
no action.

I may raise it with MS.

I have the hot fix installed, so that doesn’t help.

It’s the working for some, not others bit thats got me puzzled.

S.



> On 28 Sep 2017, at 14:18, Brucker, Chris 
> <chris.bruc...@bankatfirst.com<mailto:chris.bruc...@bankatfirst.com>> wrote:
>
> We have been seeing similar issues since our upgrade to 1706 wave 1. I 
> haven't made time yet to upgrade to wave 2 and the hotfix to see if that 
> fixes it.
>
> Another theory I have wanted to test is how often are your hardware 
> inventories, application evaluations, software update scans, etc occurring? 
> I'm a bit of a spaz about that and have hardware inventories and software 
> update scans every 12 hours. Application evaluations every 4 hours and 
> Software inventories occur every 7 days.
>
> SQL has 4 cores and 24gb of ram, SCCM has 2 cores and 12gb ram. 2700 clients.
>
> Thanks,
> Chris Brucker
>
>> On Sep 28, 2017, at 9:06 AM, Daniel Ratliff 
>> <dratl...@humana.com<mailto:dratl...@humana.com>> wrote:
>>
>> CAUTION: The e-mail below is from an EXTERNAL source. Please do not open 
>> attachments or click links from an unknown or suspicious origin.
>>
>>
>>
>> Anything in smsprov.log?
>>
>> Daniel Ratliff
>>
>> -Original Message-
>> From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
>> [mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret
>> Sent: Thursday, September 28, 2017 5:31 AM
>> To: mssms@lists.myitforum.com<mailto:mssms@lists.myit

Re: [mssms] RE: Slow Console performance for some users

2017-09-28 Thread Stuart Watret 
for me it doesn’t explain the fact some people are fine, ill open a call 
tomorrow.

On 28 Sep 2017, at 17:26, Daniel Ratliff 
<dratl...@humana.com<mailto:dratl...@humana.com>> wrote:

Its recommended to be set to 130 per the article yes, but that doesn’t mean you 
don’t have the issue.

Find a culprit query, and run the instructions they gave to see if you are 
impacted.

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff
Sent: Thursday, September 28, 2017 12:03 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: Slow Console performance for some users

Heres the details. 
https://support.microsoft.com/en-us/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-d

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Kent, Mark
Sent: Thursday, September 28, 2017 11:38 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: Slow Console performance for some users

We are running SQL2016 as well, the compatibility is set to 2016.  So you are 
recommending dropping this down to 2012?  Does this help address anything else? 
 Just curious, thank you!

Mark Kent
Manager, Client Systems Engineering
Technology Support Services
Resources for Information, Technology and Education (RITE)
http://rite.buffalostate.edu<http://rite.buffalostate.edu/>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Sandys
Sent: Thursday, September 28, 2017 10:41 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: Slow Console performance for some users

Change the compatibility level for the ConfigMgr database in SQL Server to SQL 
Server 2012 (110). There is a known issue that stems from a change in SQL 
Server 2014 and 2016 that hasn’t been accounted for (yet to my knowledge) in 
ConfigMgr.

J

-Original Message-
From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret
Sent: Thursday, September 28, 2017 8:42 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [mssms] RE: Slow Console performance for some users

What I’m seeing in that log is sql execution delays, the same time his console 
is waiting.

I do the same thing, navigate to the same package it’s almost instant.

I click, I see a sql command and my console refreshes, he clicks, same command, 
no action.

I may raise it with MS.

I have the hot fix installed, so that doesn’t help.

It’s the working for some, not others bit thats got me puzzled.

S.



> On 28 Sep 2017, at 14:18, Brucker, Chris 
> <chris.bruc...@bankatfirst.com<mailto:chris.bruc...@bankatfirst.com>> wrote:
>
> We have been seeing similar issues since our upgrade to 1706 wave 1. I 
> haven't made time yet to upgrade to wave 2 and the hotfix to see if that 
> fixes it.
>
> Another theory I have wanted to test is how often are your hardware 
> inventories, application evaluations, software update scans, etc occurring? 
> I'm a bit of a spaz about that and have hardware inventories and software 
> update scans every 12 hours. Application evaluations every 4 hours and 
> Software inventories occur every 7 days.
>
> SQL has 4 cores and 24gb of ram, SCCM has 2 cores and 12gb ram. 2700 clients.
>
> Thanks,
> Chris Brucker
>
>> On Sep 28, 2017, at 9:06 AM, Daniel Ratliff 
>> <dratl...@humana.com<mailto:dratl...@humana.com>> wrote:
>>
>> CAUTION: The e-mail below is from an EXTERNAL source. Please do not open 
>> attachments or click links from an unknown or suspicious origin.
>>
>>
>>
>> Anything in smsprov.log?
>>
>> Daniel Ratliff
>>
>> -Original Message-
>> From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
>> [mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret
>> Sent: Thursday, September 28, 2017 5:31 AM
>> To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
>> Subject: [mssms] Slow Console performance for some users
>>
>> So, finished our migration to new server running 1706.
>>
>> OS 2016 / SQL 2016 Sp1 CU5 / Compatibility 130
>>
>> Its absolutely fine for me, I have three colleagues who are also full 
>> admins, one of them is fine, the other two have appalling console 
>> performance.
>>
>> We

RE: [mssms] RE: Slow Console performance for some users

2017-09-28 Thread Daniel Ratliff 
Its recommended to be set to 130 per the article yes, but that doesn’t mean you 
don’t have the issue.

Find a culprit query, and run the instructions they gave to see if you are 
impacted.

Daniel Ratliff

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Daniel Ratliff
Sent: Thursday, September 28, 2017 12:03 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] RE: Slow Console performance for some users

Heres the details. 
https://support.microsoft.com/en-us/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-d

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Kent, Mark
Sent: Thursday, September 28, 2017 11:38 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: Slow Console performance for some users

We are running SQL2016 as well, the compatibility is set to 2016.  So you are 
recommending dropping this down to 2012?  Does this help address anything else? 
 Just curious, thank you!

Mark Kent
Manager, Client Systems Engineering
Technology Support Services
Resources for Information, Technology and Education (RITE)
http://rite.buffalostate.edu<http://rite.buffalostate.edu/>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Sandys
Sent: Thursday, September 28, 2017 10:41 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: Slow Console performance for some users


Change the compatibility level for the ConfigMgr database in SQL Server to SQL 
Server 2012 (110). There is a known issue that stems from a change in SQL 
Server 2014 and 2016 that hasn’t been accounted for (yet to my knowledge) in 
ConfigMgr.



J



-Original Message-

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret

Sent: Thursday, September 28, 2017 8:42 AM

To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>

Subject: Re: [mssms] RE: Slow Console performance for some users



What I’m seeing in that log is sql execution delays, the same time his console 
is waiting.



I do the same thing, navigate to the same package it’s almost instant.



I click, I see a sql command and my console refreshes, he clicks, same command, 
no action.



I may raise it with MS.



I have the hot fix installed, so that doesn’t help.



It’s the working for some, not others bit thats got me puzzled.



S.







> On 28 Sep 2017, at 14:18, Brucker, Chris 
> <chris.bruc...@bankatfirst.com<mailto:chris.bruc...@bankatfirst.com>> wrote:

>

> We have been seeing similar issues since our upgrade to 1706 wave 1. I 
> haven't made time yet to upgrade to wave 2 and the hotfix to see if that 
> fixes it.

>

> Another theory I have wanted to test is how often are your hardware 
> inventories, application evaluations, software update scans, etc occurring? 
> I'm a bit of a spaz about that and have hardware inventories and software 
> update scans every 12 hours. Application evaluations every 4 hours and 
> Software inventories occur every 7 days.

>

> SQL has 4 cores and 24gb of ram, SCCM has 2 cores and 12gb ram. 2700 clients.

>

> Thanks,

> Chris Brucker

>

>> On Sep 28, 2017, at 9:06 AM, Daniel Ratliff 
>> <dratl...@humana.com<mailto:dratl...@humana.com>> wrote:

>>

>> CAUTION: The e-mail below is from an EXTERNAL source. Please do not open 
>> attachments or click links from an unknown or suspicious origin.

>>

>>

>>

>> Anything in smsprov.log?

>>

>> Daniel Ratliff

>>

>> -Original Message-

>> From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
>> [mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret

>> Sent: Thursday, September 28, 2017 5:31 AM

>> To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>

>> Subject: [mssms] Slow Console performance for some users

>>

>> So, finished our migration to new server running 1706.

>>

>> OS 2016 / SQL 2016 Sp1 CU5 / Compatibility 130

>>

>> Its absolutely fine for me, I have three colleagues who are also full 
>> admins, one of them is fine, the other two have appalling console 
>> performance.

>>

>> We have removed the console and reinstalled, we have had them run the 
>> console on the server, the results are the same.

>>

>> If they drill down to a package, then click the program tab, they have the 
>> donut of doom, for a long time before it enumerates.

>>

>> This

RE: [mssms] RE: Slow Console performance for some users

2017-09-28 Thread Daniel Ratliff 
Heres the details. 
https://support.microsoft.com/en-us/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-d

Daniel Ratliff

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Kent, Mark
Sent: Thursday, September 28, 2017 11:38 AM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] RE: Slow Console performance for some users

We are running SQL2016 as well, the compatibility is set to 2016.  So you are 
recommending dropping this down to 2012?  Does this help address anything else? 
 Just curious, thank you!

Mark Kent
Manager, Client Systems Engineering
Technology Support Services
Resources for Information, Technology and Education (RITE)
http://rite.buffalostate.edu<http://rite.buffalostate.edu/>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Jason Sandys
Sent: Thursday, September 28, 2017 10:41 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: Slow Console performance for some users


Change the compatibility level for the ConfigMgr database in SQL Server to SQL 
Server 2012 (110). There is a known issue that stems from a change in SQL 
Server 2014 and 2016 that hasn’t been accounted for (yet to my knowledge) in 
ConfigMgr.



J



-Original Message-

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret

Sent: Thursday, September 28, 2017 8:42 AM

To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>

Subject: Re: [mssms] RE: Slow Console performance for some users



What I’m seeing in that log is sql execution delays, the same time his console 
is waiting.



I do the same thing, navigate to the same package it’s almost instant.



I click, I see a sql command and my console refreshes, he clicks, same command, 
no action.



I may raise it with MS.



I have the hot fix installed, so that doesn’t help.



It’s the working for some, not others bit thats got me puzzled.



S.







> On 28 Sep 2017, at 14:18, Brucker, Chris 
> <chris.bruc...@bankatfirst.com<mailto:chris.bruc...@bankatfirst.com>> wrote:

>

> We have been seeing similar issues since our upgrade to 1706 wave 1. I 
> haven't made time yet to upgrade to wave 2 and the hotfix to see if that 
> fixes it.

>

> Another theory I have wanted to test is how often are your hardware 
> inventories, application evaluations, software update scans, etc occurring? 
> I'm a bit of a spaz about that and have hardware inventories and software 
> update scans every 12 hours. Application evaluations every 4 hours and 
> Software inventories occur every 7 days.

>

> SQL has 4 cores and 24gb of ram, SCCM has 2 cores and 12gb ram. 2700 clients.

>

> Thanks,

> Chris Brucker

>

>> On Sep 28, 2017, at 9:06 AM, Daniel Ratliff 
>> <dratl...@humana.com<mailto:dratl...@humana.com>> wrote:

>>

>> CAUTION: The e-mail below is from an EXTERNAL source. Please do not open 
>> attachments or click links from an unknown or suspicious origin.

>>

>>

>>

>> Anything in smsprov.log?

>>

>> Daniel Ratliff

>>

>> -Original Message-

>> From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
>> [mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret

>> Sent: Thursday, September 28, 2017 5:31 AM

>> To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>

>> Subject: [mssms] Slow Console performance for some users

>>

>> So, finished our migration to new server running 1706.

>>

>> OS 2016 / SQL 2016 Sp1 CU5 / Compatibility 130

>>

>> Its absolutely fine for me, I have three colleagues who are also full 
>> admins, one of them is fine, the other two have appalling console 
>> performance.

>>

>> We have removed the console and reinstalled, we have had them run the 
>> console on the server, the results are the same.

>>

>> If they drill down to a package, then click the program tab, they have the 
>> donut of doom, for a long time before it enumerates.

>>

>> This is repeatable.

>>

>> Any thoughts?

>>

>> Stuart Watret

>>

>>

>>

>>

>>

>>

>>

>

> **

> The information contained in this message from First Financial Bancorp or its 
> affiliates and any attachments are confidential.  It is not intended for 
> transmission to, or receipt by, anyone other than the addressee(s), or a 
> person authorized to deliver it to the named addr

RE: [mssms] RE: Slow Console performance for some users

2017-09-28 Thread Kent, Mark 
Yeah, just read that.  It says if you are on 2016 and on 130 to leave it that 
way, which is what we have set.

Mark Kent
Manager, Client Systems Engineering
Technology Support Services
Resources for Information, Technology and Education (RITE)
http://rite.buffalostate.edu<http://rite.buffalostate.edu/>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Stuart Watret
Sent: Thursday, September 28, 2017 10:59 AM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] RE: Slow Console performance for some users

doesn’t explain why some are good though; my reading of similar articles said 
130 was recommended.
https://support.microsoft.com/en-ph/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-d



On 28 Sep 2017, at 15:41, Jason Sandys 
<ja...@sandys.us<mailto:ja...@sandys.us>> wrote:

Change the compatibility level for the ConfigMgr database in SQL Server to SQL 
Server 2012 (110). There is a known issue that stems from a change in SQL 
Server 2014 and 2016 that hasn’t been accounted for (yet to my knowledge) in 
ConfigMgr.

J

-Original Message-
From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret
Sent: Thursday, September 28, 2017 8:42 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [mssms] RE: Slow Console performance for some users

What I’m seeing in that log is sql execution delays, the same time his console 
is waiting.

I do the same thing, navigate to the same package it’s almost instant.

I click, I see a sql command and my console refreshes, he clicks, same command, 
no action.

I may raise it with MS.

I have the hot fix installed, so that doesn’t help.

It’s the working for some, not others bit thats got me puzzled.

S.



> On 28 Sep 2017, at 14:18, Brucker, Chris 
> <chris.bruc...@bankatfirst.com<mailto:chris.bruc...@bankatfirst.com>> wrote:
>
> We have been seeing similar issues since our upgrade to 1706 wave 1. I 
> haven't made time yet to upgrade to wave 2 and the hotfix to see if that 
> fixes it.
>
> Another theory I have wanted to test is how often are your hardware 
> inventories, application evaluations, software update scans, etc occurring? 
> I'm a bit of a spaz about that and have hardware inventories and software 
> update scans every 12 hours. Application evaluations every 4 hours and 
> Software inventories occur every 7 days.
>
> SQL has 4 cores and 24gb of ram, SCCM has 2 cores and 12gb ram. 2700 clients.
>
> Thanks,
> Chris Brucker
>
>> On Sep 28, 2017, at 9:06 AM, Daniel Ratliff 
>> <dratl...@humana.com<mailto:dratl...@humana.com>> wrote:
>>
>> CAUTION: The e-mail below is from an EXTERNAL source. Please do not open 
>> attachments or click links from an unknown or suspicious origin.
>>
>>
>>
>> Anything in smsprov.log?
>>
>> Daniel Ratliff
>>
>> -Original Message-
>> From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
>> [mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret
>> Sent: Thursday, September 28, 2017 5:31 AM
>> To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
>> Subject: [mssms] Slow Console performance for some users
>>
>> So, finished our migration to new server running 1706.
>>
>> OS 2016 / SQL 2016 Sp1 CU5 / Compatibility 130
>>
>> Its absolutely fine for me, I have three colleagues who are also full 
>> admins, one of them is fine, the other two have appalling console 
>> performance.
>>
>> We have removed the console and reinstalled, we have had them run the 
>> console on the server, the results are the same.
>>
>> If they drill down to a package, then click the program tab, they have the 
>> donut of doom, for a long time before it enumerates.
>>
>> This is repeatable.
>>
>> Any thoughts?
>>
>> Stuart Watret
>>
>>
>>
>>
>>
>>
>>
>
> **
> The information contained in this message from First Financial Bancorp or its 
> affiliates and any attachments are confidential.  It is not intended for 
> transmission to, or receipt by, anyone other than the addressee(s), or a 
> person authorized to deliver it to the named addressee(s).  If you have 
> received this message in error, you are prohibited from copying, distributing 
> or using the information.  Please contact the sender immediately by return 
> email and delete the original message.
>
>
>
>

Re: [mssms] RE: Slow Console performance for some users

2017-09-28 Thread Stuart Watret 
doesn’t explain why some are good though; my reading of similar articles said 
130 was recommended.
https://support.microsoft.com/en-ph/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-d



On 28 Sep 2017, at 15:41, Jason Sandys 
<ja...@sandys.us<mailto:ja...@sandys.us>> wrote:

Change the compatibility level for the ConfigMgr database in SQL Server to SQL 
Server 2012 (110). There is a known issue that stems from a change in SQL 
Server 2014 and 2016 that hasn’t been accounted for (yet to my knowledge) in 
ConfigMgr.

J

-Original Message-
From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret
Sent: Thursday, September 28, 2017 8:42 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [mssms] RE: Slow Console performance for some users

What I’m seeing in that log is sql execution delays, the same time his console 
is waiting.

I do the same thing, navigate to the same package it’s almost instant.

I click, I see a sql command and my console refreshes, he clicks, same command, 
no action.

I may raise it with MS.

I have the hot fix installed, so that doesn’t help.

It’s the working for some, not others bit thats got me puzzled.

S.



> On 28 Sep 2017, at 14:18, Brucker, Chris 
> <chris.bruc...@bankatfirst.com<mailto:chris.bruc...@bankatfirst.com>> wrote:
>
> We have been seeing similar issues since our upgrade to 1706 wave 1. I 
> haven't made time yet to upgrade to wave 2 and the hotfix to see if that 
> fixes it.
>
> Another theory I have wanted to test is how often are your hardware 
> inventories, application evaluations, software update scans, etc occurring? 
> I'm a bit of a spaz about that and have hardware inventories and software 
> update scans every 12 hours. Application evaluations every 4 hours and 
> Software inventories occur every 7 days.
>
> SQL has 4 cores and 24gb of ram, SCCM has 2 cores and 12gb ram. 2700 clients.
>
> Thanks,
> Chris Brucker
>
>> On Sep 28, 2017, at 9:06 AM, Daniel Ratliff 
>> <dratl...@humana.com<mailto:dratl...@humana.com>> wrote:
>>
>> CAUTION: The e-mail below is from an EXTERNAL source. Please do not open 
>> attachments or click links from an unknown or suspicious origin.
>>
>>
>>
>> Anything in smsprov.log?
>>
>> Daniel Ratliff
>>
>> -Original Message-
>> From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
>> [mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret
>> Sent: Thursday, September 28, 2017 5:31 AM
>> To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
>> Subject: [mssms] Slow Console performance for some users
>>
>> So, finished our migration to new server running 1706.
>>
>> OS 2016 / SQL 2016 Sp1 CU5 / Compatibility 130
>>
>> Its absolutely fine for me, I have three colleagues who are also full 
>> admins, one of them is fine, the other two have appalling console 
>> performance.
>>
>> We have removed the console and reinstalled, we have had them run the 
>> console on the server, the results are the same.
>>
>> If they drill down to a package, then click the program tab, they have the 
>> donut of doom, for a long time before it enumerates.
>>
>> This is repeatable.
>>
>> Any thoughts?
>>
>> Stuart Watret
>>
>>
>>
>>
>>
>>
>>
>
> **
> The information contained in this message from First Financial Bancorp or its 
> affiliates and any attachments are confidential.  It is not intended for 
> transmission to, or receipt by, anyone other than the addressee(s), or a 
> person authorized to deliver it to the named addressee(s).  If you have 
> received this message in error, you are prohibited from copying, distributing 
> or using the information.  Please contact the sender immediately by return 
> email and delete the original message.
>
>
>
>

RE: [mssms] RE: Slow Console performance for some users

2017-09-28 Thread Kent, Mark 
We are running SQL2016 as well, the compatibility is set to 2016.  So you are 
recommending dropping this down to 2012?  Does this help address anything else? 
 Just curious, thank you!

Mark Kent
Manager, Client Systems Engineering
Technology Support Services
Resources for Information, Technology and Education (RITE)
http://rite.buffalostate.edu<http://rite.buffalostate.edu/>

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Jason Sandys
Sent: Thursday, September 28, 2017 10:41 AM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] RE: Slow Console performance for some users


Change the compatibility level for the ConfigMgr database in SQL Server to SQL 
Server 2012 (110). There is a known issue that stems from a change in SQL 
Server 2014 and 2016 that hasn’t been accounted for (yet to my knowledge) in 
ConfigMgr.



J



-Original Message-

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret

Sent: Thursday, September 28, 2017 8:42 AM

To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>

Subject: Re: [mssms] RE: Slow Console performance for some users



What I’m seeing in that log is sql execution delays, the same time his console 
is waiting.



I do the same thing, navigate to the same package it’s almost instant.



I click, I see a sql command and my console refreshes, he clicks, same command, 
no action.



I may raise it with MS.



I have the hot fix installed, so that doesn’t help.



It’s the working for some, not others bit thats got me puzzled.



S.







> On 28 Sep 2017, at 14:18, Brucker, Chris 
> <chris.bruc...@bankatfirst.com<mailto:chris.bruc...@bankatfirst.com>> wrote:

>

> We have been seeing similar issues since our upgrade to 1706 wave 1. I 
> haven't made time yet to upgrade to wave 2 and the hotfix to see if that 
> fixes it.

>

> Another theory I have wanted to test is how often are your hardware 
> inventories, application evaluations, software update scans, etc occurring? 
> I'm a bit of a spaz about that and have hardware inventories and software 
> update scans every 12 hours. Application evaluations every 4 hours and 
> Software inventories occur every 7 days.

>

> SQL has 4 cores and 24gb of ram, SCCM has 2 cores and 12gb ram. 2700 clients.

>

> Thanks,

> Chris Brucker

>

>> On Sep 28, 2017, at 9:06 AM, Daniel Ratliff 
>> <dratl...@humana.com<mailto:dratl...@humana.com>> wrote:

>>

>> CAUTION: The e-mail below is from an EXTERNAL source. Please do not open 
>> attachments or click links from an unknown or suspicious origin.

>>

>>

>>

>> Anything in smsprov.log?

>>

>> Daniel Ratliff

>>

>> -Original Message-

>> From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
>> [mailto:listsad...@lists.myitforum.com] On Behalf Of Stuart Watret

>> Sent: Thursday, September 28, 2017 5:31 AM

>> To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>

>> Subject: [mssms] Slow Console performance for some users

>>

>> So, finished our migration to new server running 1706.

>>

>> OS 2016 / SQL 2016 Sp1 CU5 / Compatibility 130

>>

>> Its absolutely fine for me, I have three colleagues who are also full 
>> admins, one of them is fine, the other two have appalling console 
>> performance.

>>

>> We have removed the console and reinstalled, we have had them run the 
>> console on the server, the results are the same.

>>

>> If they drill down to a package, then click the program tab, they have the 
>> donut of doom, for a long time before it enumerates.

>>

>> This is repeatable.

>>

>> Any thoughts?

>>

>> Stuart Watret

>>

>>

>>

>>

>>

>>

>>

>

> **

> The information contained in this message from First Financial Bancorp or its 
> affiliates and any attachments are confidential.  It is not intended for 
> transmission to, or receipt by, anyone other than the addressee(s), or a 
> person authorized to deliver it to the named addressee(s).  If you have 
> received this message in error, you are prohibited from copying, distributing 
> or using the information.  Please contact the sender immediately by return 
> email and delete the original message.

>

>

>

>

RE: [mssms] RE: Slow Console performance for some users

2017-09-28 Thread Jason Sandys 
Change the compatibility level for the ConfigMgr database in SQL Server to SQL 
Server 2012 (110). There is a known issue that stems from a change in SQL 
Server 2014 and 2016 that hasn’t been accounted for (yet to my knowledge) in 
ConfigMgr.



J



-Original Message-

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Stuart Watret

Sent: Thursday, September 28, 2017 8:42 AM

To: mssms@lists.myitforum.com

Subject: Re: [mssms] RE: Slow Console performance for some users



What I’m seeing in that log is sql execution delays, the same time his console 
is waiting.



I do the same thing, navigate to the same package it’s almost instant.



I click, I see a sql command and my console refreshes, he clicks, same command, 
no action.



I may raise it with MS.



I have the hot fix installed, so that doesn’t help.



It’s the working for some, not others bit thats got me puzzled.



S.







> On 28 Sep 2017, at 14:18, Brucker, Chris <chris.bruc...@bankatfirst.com> 
> wrote:

>

> We have been seeing similar issues since our upgrade to 1706 wave 1. I 
> haven't made time yet to upgrade to wave 2 and the hotfix to see if that 
> fixes it.

>

> Another theory I have wanted to test is how often are your hardware 
> inventories, application evaluations, software update scans, etc occurring? 
> I'm a bit of a spaz about that and have hardware inventories and software 
> update scans every 12 hours. Application evaluations every 4 hours and 
> Software inventories occur every 7 days.

>

> SQL has 4 cores and 24gb of ram, SCCM has 2 cores and 12gb ram. 2700 clients.

>

> Thanks,

> Chris Brucker

>

>> On Sep 28, 2017, at 9:06 AM, Daniel Ratliff <dratl...@humana.com> wrote:

>>

>> CAUTION: The e-mail below is from an EXTERNAL source. Please do not open 
>> attachments or click links from an unknown or suspicious origin.

>>

>>

>>

>> Anything in smsprov.log?

>>

>> Daniel Ratliff

>>

>> -Original Message-

>> From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] 
>> On Behalf Of Stuart Watret

>> Sent: Thursday, September 28, 2017 5:31 AM

>> To: mssms@lists.myitforum.com

>> Subject: [mssms] Slow Console performance for some users

>>

>> So, finished our migration to new server running 1706.

>>

>> OS 2016 / SQL 2016 Sp1 CU5 / Compatibility 130

>>

>> Its absolutely fine for me, I have three colleagues who are also full 
>> admins, one of them is fine, the other two have appalling console 
>> performance.

>>

>> We have removed the console and reinstalled, we have had them run the 
>> console on the server, the results are the same.

>>

>> If they drill down to a package, then click the program tab, they have the 
>> donut of doom, for a long time before it enumerates.

>>

>> This is repeatable.

>>

>> Any thoughts?

>>

>> Stuart Watret

>>

>>

>>

>>

>>

>>

>>

>

> **

> The information contained in this message from First Financial Bancorp or its 
> affiliates and any attachments are confidential.  It is not intended for 
> transmission to, or receipt by, anyone other than the addressee(s), or a 
> person authorized to deliver it to the named addressee(s).  If you have 
> received this message in error, you are prohibited from copying, distributing 
> or using the information.  Please contact the sender immediately by return 
> email and delete the original message.

>

>

>

>

Re: [mssms] RE: Slow Console performance for some users

2017-09-28 Thread Stuart Watret 
What I’m seeing in that log is sql execution delays, the same time his console 
is waiting.

I do the same thing, navigate to the same package it’s almost instant.

I click, I see a sql command and my console refreshes, he clicks, same command, 
no action.

I may raise it with MS.

I have the hot fix installed, so that doesn’t help.

It’s the working for some, not others bit thats got me puzzled.

S.



> On 28 Sep 2017, at 14:18, Brucker, Chris  
> wrote:
> 
> We have been seeing similar issues since our upgrade to 1706 wave 1. I 
> haven't made time yet to upgrade to wave 2 and the hotfix to see if that 
> fixes it.
> 
> Another theory I have wanted to test is how often are your hardware 
> inventories, application evaluations, software update scans, etc occurring? 
> I'm a bit of a spaz about that and have hardware inventories and software 
> update scans every 12 hours. Application evaluations every 4 hours and 
> Software inventories occur every 7 days.
> 
> SQL has 4 cores and 24gb of ram, SCCM has 2 cores and 12gb ram. 2700 clients.
> 
> Thanks,
> Chris Brucker
> 
>> On Sep 28, 2017, at 9:06 AM, Daniel Ratliff  wrote:
>> 
>> CAUTION: The e-mail below is from an EXTERNAL source. Please do not open 
>> attachments or click links from an unknown or suspicious origin.
>> 
>> 
>> 
>> Anything in smsprov.log?
>> 
>> Daniel Ratliff
>> 
>> -Original Message-
>> From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] 
>> On Behalf Of Stuart Watret
>> Sent: Thursday, September 28, 2017 5:31 AM
>> To: mssms@lists.myitforum.com
>> Subject: [mssms] Slow Console performance for some users
>> 
>> So, finished our migration to new server running 1706.
>> 
>> OS 2016 / SQL 2016 Sp1 CU5 / Compatibility 130
>> 
>> Its absolutely fine for me, I have three colleagues who are also full 
>> admins, one of them is fine, the other two have appalling console 
>> performance.
>> 
>> We have removed the console and reinstalled, we have had them run the 
>> console on the server, the results are the same.
>> 
>> If they drill down to a package, then click the program tab, they have the 
>> donut of doom, for a long time before it enumerates.
>> 
>> This is repeatable.
>> 
>> Any thoughts?
>> 
>> Stuart Watret
>> 
>> 
>> 
>> 
>> 
>> 
>> 
> 
> **
> The information contained in this message from First Financial Bancorp or its 
> affiliates and any attachments are confidential.  It is not intended for 
> transmission to, or receipt by, anyone other than the addressee(s), or a 
> person authorized to deliver it to the named addressee(s).  If you have 
> received this message in error, you are prohibited from copying, distributing 
> or using the information.  Please contact the sender immediately by return 
> email and delete the original message.
> 
> 
> 
>

RE: [mssms] RE: Slow Console performance for some users

2017-09-28 Thread Daniel Ratliff 
Chris, offhand, I think those specs are WAY underspecced. Check the new specs 
for CB. 

We run HINV daily, update scans daily, don't use applications, and SINV is 
every 14 days. 

Daniel Ratliff


-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Brucker, Chris
Sent: Thursday, September 28, 2017 9:19 AM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] RE: Slow Console performance for some users

We have been seeing similar issues since our upgrade to 1706 wave 1. I haven't 
made time yet to upgrade to wave 2 and the hotfix to see if that fixes it.

Another theory I have wanted to test is how often are your hardware 
inventories, application evaluations, software update scans, etc occurring? I'm 
a bit of a spaz about that and have hardware inventories and software update 
scans every 12 hours. Application evaluations every 4 hours and Software 
inventories occur every 7 days.

SQL has 4 cores and 24gb of ram, SCCM has 2 cores and 12gb ram. 2700 clients.

Thanks,
Chris Brucker

> On Sep 28, 2017, at 9:06 AM, Daniel Ratliff <dratl...@humana.com> wrote:
> 
> CAUTION: The e-mail below is from an EXTERNAL source. Please do not open 
> attachments or click links from an unknown or suspicious origin.
> 
> 
> 
> Anything in smsprov.log?
> 
> Daniel Ratliff
> 
> -Original Message-
> From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] 
> On Behalf Of Stuart Watret
> Sent: Thursday, September 28, 2017 5:31 AM
> To: mssms@lists.myitforum.com
> Subject: [mssms] Slow Console performance for some users
> 
> So, finished our migration to new server running 1706.
> 
> OS 2016 / SQL 2016 Sp1 CU5 / Compatibility 130
> 
> Its absolutely fine for me, I have three colleagues who are also full admins, 
> one of them is fine, the other two have appalling console performance.
> 
> We have removed the console and reinstalled, we have had them run the console 
> on the server, the results are the same.
> 
> If they drill down to a package, then click the program tab, they have the 
> donut of doom, for a long time before it enumerates.
> 
> This is repeatable.
> 
> Any thoughts?
> 
> Stuart Watret
> 
> 
> 
> 
> 
> 
> 

**
The information contained in this message from First Financial Bancorp or its 
affiliates and any attachments are confidential.  It is not intended for 
transmission to, or receipt by, anyone other than the addressee(s), or a person 
authorized to deliver it to the named addressee(s).  If you have received this 
message in error, you are prohibited from copying, distributing or using the 
information.  Please contact the sender immediately by return email and delete 
the original message.

Re: [mssms] RE: Slow Console performance for some users

2017-09-28 Thread Brucker, Chris 
We have been seeing similar issues since our upgrade to 1706 wave 1. I haven't 
made time yet to upgrade to wave 2 and the hotfix to see if that fixes it.

Another theory I have wanted to test is how often are your hardware 
inventories, application evaluations, software update scans, etc occurring? I'm 
a bit of a spaz about that and have hardware inventories and software update 
scans every 12 hours. Application evaluations every 4 hours and Software 
inventories occur every 7 days.

SQL has 4 cores and 24gb of ram, SCCM has 2 cores and 12gb ram. 2700 clients.

Thanks,
Chris Brucker

> On Sep 28, 2017, at 9:06 AM, Daniel Ratliff  wrote:
> 
> CAUTION: The e-mail below is from an EXTERNAL source. Please do not open 
> attachments or click links from an unknown or suspicious origin.
> 
> 
> 
> Anything in smsprov.log?
> 
> Daniel Ratliff
> 
> -Original Message-
> From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] 
> On Behalf Of Stuart Watret
> Sent: Thursday, September 28, 2017 5:31 AM
> To: mssms@lists.myitforum.com
> Subject: [mssms] Slow Console performance for some users
> 
> So, finished our migration to new server running 1706.
> 
> OS 2016 / SQL 2016 Sp1 CU5 / Compatibility 130
> 
> Its absolutely fine for me, I have three colleagues who are also full admins, 
> one of them is fine, the other two have appalling console performance.
> 
> We have removed the console and reinstalled, we have had them run the console 
> on the server, the results are the same.
> 
> If they drill down to a package, then click the program tab, they have the 
> donut of doom, for a long time before it enumerates.
> 
> This is repeatable.
> 
> Any thoughts?
> 
> Stuart Watret
> 
> 
> 
> 
> 
> 
> 

**
The information contained in this message from First Financial Bancorp or its 
affiliates and any attachments are confidential.  It is not intended for 
transmission to, or receipt by, anyone other than the addressee(s), or a person 
authorized to deliver it to the named addressee(s).  If you have received this 
message in error, you are prohibited from copying, distributing or using the 
information.  Please contact the sender immediately by return email and delete 
the original message.