Question : It’s my understanding, based on numerous sources (including this one: https://techcommunity.microsoft.com/t5/sql-server/migrating-sap-workloads-to-sql-server-just-got-2-5x-faster/ba-p/384910) that SQL Server Trace Flag 715 should […]
Tag: logging
How to find out WHERE a PG error/warning/log happened?
Question : I have PostgreSQL CSV-log its “errors” according to this structure: https://www.postgresql.org/docs/12/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG It doesn’t include the file path to […]
How to disable the logging of parameter values in PostgreSQL
Question : Is there a way to disable the logging of the parameter values used in a query, while still […]
PostgreSQL failsafe start after disk crash
Question : We use PostgreSQL to store logs. A disk crashed and some files in the file system were corrupt. […]
how can I divide log files for specific DB queries?
Question : Currently my db has a couple of triggers for some (not all) tables that get executed when a […]
Replication with encrypted columns, does the 2nd server have to have the same master key and symmetric key or is it done automatically?
Question : I have two questions actually: If you set up a table with encrypted columns and replicate it to […]
See X-Request-ID in error messages of PostgreSQL
Question : In my environment most PostgreSQL queries are generated from http requests. In my case every http request has […]
What should I do about PostgreSQL logging so much “weird noise” in its own log?
Question : PostgreSQL 12.4 on Windows 10 Pro 2004. With the default configuration file, I start PostgreSQL with pg_ctl and […]
Having issues with postgresql, what should I log?
Question : Here’s the error message I am receiving. could not translate host name “localhost” to address: hostname nor servname […]
How do I get access logs from SQL Server database [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]