Search the Community
Showing results for tags 'sql server'.
Found 6 results
Tempdb continually filling after sql server gets hung on a process
xerxes2985 posted a question in SQL ServerIn SCCM, any time I attempt to update a collection, it causes tempdb to fill up, and eventually causes SQL server to stop working properly. SQL Server databases reside on their own drive, and each time it gets hung on SMS_COLLECTION_AUXILIARY_EVALUATOR. I've specified a 50 GB limit for tempdb and a 30 GB limit for the log db. Any suggestions.
sql server is not monitored in scom 2012 r2hi I have scom 2012 installed and I installed agent on multiple servers such as sql server 2008 2012 2014 . it was working fine and monitored all servers .bu today I just saw that sql server 2012 monitoring dashboard is all grayed I waited for a while but nothing happens .I Installed agents again on that server .but nothing is showing in dashboard .the agent is showing healthy .and I can see the server computer in my console ,but not in sql 2012 instance summary and database engines. please help me .thanks a millions
SCVMM usage and feature set
cobramaster298 posted a question in System Center Virtual Machine ManagerI'm thinking of recommending my team to adopt SCVMM for windows server administration but wanted to know from an IT audience perspective: - Are you using SCVMM today? If not, what other products do you prefer to use? - What are the top 3 features you use within SCVMM that makes system/server administration easy? - How hard was it to make SCVMM a part of your toolset? Thanks, Billy
Hello All, I wanted to share this article/post that I wrote recently about an error I encountered while installing Service Manager to a named instance of SQL Server. URL: http://adinermie.wordpress.com/2014/03/26/service-manager-2012-r2-installation-fails-to-identify-sql-server-instance-and-throws-access-denied-error/ Don't forget to check out my blog regularly, as I post article there first before re-posting here.
I'm planning to install a secondary site server in my SCCM 2012 SP1 hierarchy and wanted to know if I should install the SQL Express(which installs by default) or install a new instance of SQL server 2012 enterprise? My primary site server is currently running remotely on SQL Server 2012 SP1. Thanks, Paul
Local vs Remote SQL Server 2012 Installation
pnyce24 posted a topic in Configuration Manager 2012Hey All, I just installed SCCM 2012 in my test environment, with a remote sql 2012 server. However, as I read more documentation on 2012, experts or so call experts say I should install SQL server 2012 locally on the same primary site server. The main reason they say is for permissions simplicity. However, when I install 2012 in production should I install SQL 2012 server local or on remote server. Current Site Hierarchy Primary Site 3 Secondary Sites at remote locations Total Clients: 500-1000 at each site. Thanks, Paul