Question : We’ve got a production DB server on SQL 2005. Everything runs normally for a while, but after a […]
Tag: configuration
is there a rule for the size of the page file on dedicated sql server servers?
Question : Hi All, We’ve been investigating further into the C: disk on my_server in regards to the low disk […]
How can I remove a channel from replication slave?
Question : Today my question is about MySQL replication cleanup. I used mysqldump with the –master-info –all-databases tag and restored […]
Allow access for localhost and named server
Question : I’m trying to set up a user to allow them access from localhost and from a specific named […]
How to enable CLR on a remote SQL Server?
Question : I have been created a dll for SQL Server 2014 to add some custom functions for my stored […]
SSAS – what could I monitor in SSAS to fine tune its memory settings?
Question : This question is a follow up from the SSAS – what could be a good starting point for […]
SQL Server starts normally from Windows Services screen, but shows error through SQL Server Configuration Manager. Why?
Question : I have a SQL Server 2005 instance that has worked fine for years. There have been no changes […]
Why is turning on Event Scheduler Maxing my CPU?
Question : I have search the web for the last week trying to figure this out. I have exported my […]
MongoDB — Failed global initialization: Failed to open “/var/log/mongodb/mongod-config.log”
Question : I’m trying to setup the config servers for mongodb sharding. I created a specific config file that is […]
MySQL Tuner returns: MySQL’s maximum memory usage is dangerously high
Question : Can someone help me optimize my MSQL configuration. I run Zabbix and Grafana on a Ubuntu 18.4. MySQL […]