New answers tagged

0

Check for high traffic users using MyISAM or ARIA table engine. I run CloudLinux cpanel boxes and even with CPU throttling a single high volume user with lots of writes to MyISAM table can lock the whole server up.


0

I had this on Raspberry Pi as well as on my Ubuntu server. “Job for mongod.service failed. See 'systemctl status mongod.service' and 'journalctl -xn' for details.” I had this issue on different occasions for different reasons: Mis-named .conf file – The mongodb script (which I moved to /etc/init.d/mongodb), line 57 CONF=/etc/mongod.conf when my ...


0

SQL doesn't support database files on SMB prior to 2012. Otherwise it would be possible but not recommended. Your priority should be regular backups of system and user databases, which can be done to an SMB share (best way to do it actually!)


8

If you are asking whether it is possible to enforce the database defaults for every connection that ever happens on the server, then no. Those defaults only take effect if something contradictory isn't set at the connection level. In any individual batch in SSMS you can use statements like SET ANSI_NULLS ON, SET ANSI_NULLS OFF, SET QUOTED_IDENTIFIER ON, and ...


0

Community Wiki answer generated from question comments by a_horse_with_no_name Try setting dynamic_shared_memory_type = none in postgresql.conf. "Permission denied" seems to indicate that the permissions for the user under which the service runs have been changed.


0

You can always check MySQL manual if a variable is dynamic: http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_lower_case_table_names Unfortunately lower_case_table_names is not. So you have to restart MySQL to make this variable picked up.


1

A busy SharePoint site is expected to have a lot of users which generate a huge volume of simple database requests. If you had 8 cores and 200 users, you'd fill the queues parallelising just a few user's worth of workloads. By forcing each workload onto one core, you are ensuring a better "minimum standard" experience for everyone while reducing the time ...


2

After you modify any of these settings it's common to lose connections until you restart the instance (and sometimes Browser too if you're using it). We have a policy not to do it without an outage window.


0

To be honest, I wouldn't want my database on a NAS as it is most likely accessed throughout the office and it is also very vulnerable as everyone connects to it. Ideally, your SQL database should be hidden in the deepest parts of your network. However, I seeing how this doesn't sound like a high end operation, I would see if they can give you the money to ...


1

The counter Memory Manager: Free Memory (KB) tells you below. Read the BOL document Free Memory (KB): Specifies the amount of committed memory currently not used by the server. So what this means is of all committed memory SQL Server is not using 40 MB of the memory. This is not telling you free memory on the SQL Server system. A committed memory is ...


0

"RPS" -- Requests/Sec? Is that INSERTs? SELECTs? Some combination? If it is mostly writes, then turn off the Query cache -- query_cache_type=0 and query_cache_size=0. This will eliminate the need to purge the QC. 1% RAM? If you are using MyISAM, then increase key_buffer_size to 20% of available RAM. If you are using InnoDB, then set ...


8

If you have absolutely have to use a function (a limitation of your ETL tool as you imply), you can specify OPTION as part of a multi-statement table-valued function, eg something like this: CREATE FUNCTION dbo.udf_MyFunction ( @StartID INT ) RETURNS @tv TABLE ( id INT ) AS BEGIN WITH Episodes( xlevel, PersonID, EventID, EpisodeID, StartDT, EndDT ) AS ...


9

If your queries have a common shape, you might be able to add the required maxrecursion hint using one or more plan guides. There can be a knack to getting them right. If you add specific query details to your question, we might be able to work that out for you. Typically, you would trace the SQL actually hitting the server, or obtain a parameterized form ...


1

I took inspiration from this topic. Here's what I've done to solve the problem. CREATE FUNCTION MySchema.udf_MyFunction(@StartID INT) RETURNS TABLE AS RETURN WITH Episodes(PersonID, EventID, EpisodeID, StartDT, EndDT) AS ( -- Anchor case - the first EventID for each person. SELECT PersonID, EventID, @StartID, StartDT, EndDT FROM ...


1

I just want to know why SQL Memory increase whenever runs stored procedures. Because SQL Server is a messy. It tries to keep everything it ever reads. The idea behind this is that using memory is faster than using disc. Not sure you agree here - the rest of the world does. After I stopped and restarted SQL. The memory just has 1 GB. Because right ...



Top 50 recent answers are included