Viewing 15 posts - 376 through 390 (of 2,044 total)
I wouldn't activate lock pages in memory SQL Server Max Memory Setting with Lock Pages in Memory (mssqltips.com)
The pagefile is rather for unexpected events, otherwise it has too few memory....
February 22, 2021 at 4:08 pm
Thanks for the updated funtion
February 19, 2021 at 9:49 am
Also curious for other opinions
Since you only have one pair of drives I would keep it on a single partition with you can extend when needed.
For the pagefile I would...
February 19, 2021 at 9:42 am
The FTP-transfer is still binary ? (corruption with non-binary transfer)
February 19, 2021 at 9:29 am
What is the oldest open transaction ? DBCC OPENTRAN
February 15, 2021 at 1:34 pm
SCOM 2019 SSRS would refuse to install because the version was too high (it needed the RTM SQL Server (sigh)). I'll try it again on my laptop (uninstall sql, install...
February 12, 2021 at 9:58 pm
Maybe farfetched but is your sql server still RTM? I had problems with SCOM 2019 installation when the sql server was already patched and the "versions" didn't match (had to...
February 12, 2021 at 8:21 am
Are the sql server files excluded from antivirus?
Does it relate to backup times (more stress on io) / higher cpu usage ( certain batch with lot of iops)?
February 11, 2021 at 10:17 am
Found one with a youtube movie https://joeschoice.com/sslandmssql/
February 11, 2021 at 9:42 am
Can't see your screenshot.
As an alternative you can import the certificate using the mcc certificate snapin
https://codekabinett.com/rdumps.php?Lang=2&targetDoc=create-install-ssl-tls-certificate-sql-server
It might be need to assign read permissions on the certificate in order to be...
February 10, 2021 at 3:52 pm
No more named SSRS instances since SQL 2017 https://itsalljustelectrons.blogspot.com/2018/01/Installing-SSRS-2017.html
February 10, 2021 at 10:28 am
sqlsni.trace seems to be removed in CU8 probably for fix 13671396 XEvent sqlsni.sni_trace does not fire unless sqlsni.trace is enabled in SQL Server 2019.
Thanks to stummsft for a helper function
February 4, 2021 at 4:36 pm
Solved: On SQL2019 it's called sqlsni.sni_trace instead of sqlsni.trace
February 4, 2021 at 4:09 pm
Test before you try this
Now it is more clear (misread domainy). You want to change the domain of the client and make sure the acces to the original sql servers...
February 2, 2021 at 9:31 am
Viewing 15 posts - 376 through 390 (of 2,044 total)