Hello I'm Facing Performance issue with SCCM 2012 Console , all Rules and SQL Db on Same Physical Server with the following Specs:

24 Cores and 28 GB of Memory.

thanks

Is the slowness specific to an area of the console or overal? Have you tried the console remotely?

loading all workspaces take long time

Can you provide a few more details. What else do you have running on the server (other apps, site system roles, synchronization processes, number of clients etc). Do you have any I/O issues, processor issues, memory leaks etc

How much Memory is the console process consuming? Is it also slow when closing and re-opening the console?

Is SQL configured to use a minimum of 8gb of Memory?

Also if SQL is not co-located on the same server as SCCm it needs to be configured for 50-80% of the available memory. Look at this link under SQL Server requirements.

http://technet.microsoft.com/en-us/library/gg682077.aspx

Thanks,

Tom

hi ahmed, is your console slow issue was resolved , i have same issue. the server don't have memory/cpu presure

Have you enabled "Rebuild Indexes" under "Administration" -> "Site Configuration" -> "Site Maintenance" ?

If the reindexing task doesn't help -- which it often does but sometimes does not, then you should implement a SQL maintenance plan directly in your SQL instance. Something like this is very effective: http://stevethompsonmvp.wordpress.com/2013/05/07/optimizing-configmgr-databases/

Are you using Endpoint Protection?  Actually, regardless of your AV client choice, make sure that you have an exclusion in place for the smsprov.log on your primary server(s). 

You can see if this is the issue by running Process Monitor on your server and look for the AV service (MsMpEng.exe) causing lock events on this log file.  I've seen this a couple of times now, and by excluding this log file from Real Time Protection, the console has sped up exponentially. 

which SCCM version are you using & which cumulative update is installed?