No announcements
Found 35680 threads
-
0 Votessys.dm_os_memory_pools pool_id
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-memory-pools-transact-sql?view=sql-server-ver15 By default pool_id 0 is internal ...Unanswered | 8 Replies | 4943 Views | Created by sakurai_db - Tuesday, August 11, 2020 4:02 AM | Last reply by sakurai_db - Sunday, August 30, 2020 9:55 AM
-
0 Votes
what's actually CMEMTHREAD
https://www.sqlskills.com/help/waits/cmemthread/ what's actually "TREAD-safe-memory-object" ?Proposed | 8 Replies | 4835 Views | Created by sakurai_db - Tuesday, August 11, 2020 8:38 AM | Last reply by sakurai_db - Friday, August 28, 2020 5:23 PM -
0 Votes
Multipage allocation vs Large Pageallocation
May I know Multipage allocation vs Large Pageallocation are the same concept ? Any example of what type of Multipage allocation are? I check in my ...Proposed | 16 Replies | 5688 Views | Created by sakurai_db - Tuesday, August 11, 2020 3:32 AM | Last reply by sakurai_db - Friday, August 28, 2020 8:39 AM -
0 Votes
DBCC memory status Current commited
May i know if the current committed will also include stack memory allocation ? (which is not control by max server memory ) ?Answered | 15 Replies | 5356 Views | Created by sakurai_db - Tuesday, August 11, 2020 9:13 AM | Last reply by sakurai_db - Friday, August 28, 2020 8:38 AM -
0 Votes
Filter index question
I am comming to this example https://www.mssqltips.com/sqlservertip/2353/performance-advantages-of-sql-server-filtered-statistics/ CREATE TABLE ...Unanswered | 5 Replies | 4128 Views | Created by sakurai_db - Thursday, August 13, 2020 6:12 AM | Last reply by sakurai_db - Friday, August 28, 2020 8:36 AM -
2 Votes
SQL Server 2016 slower than SQL Server 2008
I have two databases with the same data, one on an SQL Server 2008 R2 instance, and one on an SQL Server 2016 instance. Both SQL Server instances are on the same machine, and the database files are on ...Unanswered | 31 Replies | 15209 Views | Created by pappasa - Thursday, March 22, 2018 8:14 AM | Last reply by jchang61 - Tuesday, August 25, 2020 5:09 PM -
0 Votes
dm_os_ring_buffers :RING_BUFFER_OOM'
;WITH rb AS ( SELECT CAST (record as xml) record_xml FROM sys.dm_os_ring_buffers WHERE ring_buffer_type = ...Unanswered | 4 Replies | 4582 Views | Created by sakurai_db - Wednesday, August 12, 2020 9:56 AM | Last reply by sakurai_db - Tuesday, August 25, 2020 9:47 AM -
0 Votes
SQL Server resource pool MAX_MEMORY_PERCENT
MIN_MEMORY_PERCENT and MAX_MEMORY_PERCENT These settings are the minimum and maximum amount of memory reserved for the resource pool that can not be shared with ...Answered | 3 Replies | 4701 Views | Created by sakurai_db - Wednesday, August 12, 2020 9:14 AM | Last reply by sakurai_db - Tuesday, August 25, 2020 9:46 AM -
0 Votes
Transaction Log recovery phases
https://docs.microsoft.com/en-us/azure/azure-sql/accelerated-database-recovery I am not quite sure the design for Phase 2 Redo , why it's not start scanning from the last commit lsn ...Proposed | 7 Replies | 4915 Views | Created by sakurai_db - Thursday, August 13, 2020 3:15 AM | Last reply by Shanky_621 - Saturday, August 22, 2020 2:01 PM -
0 Votes
Recompile or DISABLE_PARAMETER_SNIFFING
If I would like to make the query to compile the plan for individual parameter, should I should recompile or DISABLE_PARAMETER_SNIFFING? What's the ...Answered | 9 Replies | 5602 Views | Created by sakurai_db - Thursday, July 23, 2020 4:39 PM | Last reply by Erland Sommarskog - Saturday, August 22, 2020 1:24 PM -
0 Votes
SQL Server soft-numa
If the server has 2 socket and each has 8 phyiscal core per each. and enable hardware numa. So SQL Server 2016 will still do the auto-software numa configuration during startup ?Proposed | 10 Replies | 5225 Views | Created by sakurai_db - Tuesday, August 11, 2020 3:00 AM | Last reply by sakurai_db - Friday, August 21, 2020 4:29 AM -
3 Votes
Default trace was stopped because of an error. Cause: 0x80070057(The parameter is incorrect.).
Hello, We have MS SQL server 2016 Enterprise (SP2-CU5). After starting the server, the default trace file grows to 20 MB, and then stops with this error in ...Proposed | 17 Replies | 7058 Views | Created by GRikhter - Thursday, June 18, 2020 5:21 AM | Last reply by GRikhter - Thursday, August 20, 2020 7:57 AM -
0 Votes
max worker thread
If I have a server have 16 cores , 64 bits, can I tune max worker thread (instance setting) to 1000 ? And if calculating max worker thread will be using physical core or ...Answered | 9 Replies | 4623 Views | Created by sakurai_db - Sunday, August 9, 2020 9:22 AM | Last reply by Amelia Gu - Wednesday, August 19, 2020 9:32 AM -
0 Votes
Safely stop full text catalog population?
SQL Server 2008 R2 We noticed that one of our full text catalogs was incorrectly set to "Do not track changes" with a "Last population date" set months ago. As ...Unanswered | 4 Replies | 4523 Views | Created by BigSancho - Wednesday, August 5, 2020 5:58 PM | Last reply by Amelia Gu - Wednesday, August 19, 2020 9:27 AM -
0 Votes
TDE with Keyvault
I am reading this ...Answered | 4 Replies | 4179 Views | Created by sakurai_db - Wednesday, August 5, 2020 3:02 AM | Last reply by Amelia Gu - Wednesday, August 19, 2020 9:25 AM -
0 Votes
The network name cannot be found at System.Data.SqlTypes.SqlFileStream.OpenSqlFileStream
System.REta.SqlClient.SqlException: The network name cannot be found ---> System.ComponentModel.Win32Exception: The network name cannot be found at ...Unanswered | 4 Replies | 4781 Views | Created by Kumar GK - Monday, August 10, 2020 11:46 AM | Last reply by Kumar GK - Wednesday, August 19, 2020 5:06 AM -
0 Votes
Cost in Execution Plan summing up more than 100% , its some where 140%+
Hi All I am using Azure SQL, while performance tuning I found one of the queries generated execution plan value more than 140% Query plan attached, Can you help ...Unanswered | 11 Replies | 7064 Views | Created by Saurabh Sinha DBA - Friday, June 8, 2018 5:59 AM | Last reply by pituach - Tuesday, August 18, 2020 7:33 PM -
1 Votes
Index Reorganize during Database Full Backup
Index Maintenance usually starts 3 Hours before the database full backup and ends before the Full Backup Start. The Database is in Simple Recovery Model. Last ...Answered | 7 Replies | 5105 Views | Created by Osama Waly - Sunday, May 20, 2018 9:09 AM | Last reply by DBA-Kirtan_12 - Tuesday, August 18, 2020 10:44 AM -
0 Votes
MSDN subscription
how to associate a sql server database to an MSDN subscriptionUnanswered | 4 Replies | 4730 Views | Created by Pigoclau - Friday, August 14, 2020 9:56 PM | Last reply by MIAOYUXI - Tuesday, August 18, 2020 1:10 AM -
0 Votes
How to interpret Native Compilation Advisor report
so which code is blocking this procedure to natively compileAnswered | 2 Replies | 4148 Views | Created by sakurai_db - Monday, August 17, 2020 6:33 AM | Last reply by Erland Sommarskog - Monday, August 17, 2020 9:11 PM - Items 1 to 20 of 35680 Next ›
No announcements
