Can we create index on msdb database for backupset objects
Oct 24, 2013 · I am using sql server 2008 with sp3. I want to confirm whether we can create index on msdb database for backupset objects or not. what is the purpose of this ???
Enterprise t-sql Stored Procs against tables -vs- Views
Sep 17, 2010 · Stored procs often improve performance because SQL Server can cache the query plan for the stored procedure. SQL Server can also cache plans for "ad hoc" …
SSAS Tabular - Memory Usage Behaviour
Mar 10, 2014 · SQL Server Analysis Services (SSAS) Tabular mode runs in memory. It will load tabular models into memory on startup, other than load entire database into memory. And I …
how sql server scheduler works, can it use all assigned cores smartly?
Nov 20, 2017 · Question 0 Sign in to vote Hi All,<o:p></o:p> Just curious that half of the total CPU cores, that is 16 cores have been assigned to this SQL instances, but when checking running …
Could not obtain exclusive lock on database ‘model’.
Oct 17, 2018 · Could not obtain exclusive lock on database ‘model’. Retry the operation later. CREATE DATABASE failed Tuesday, October 16, 2018 2:43 PM
tempdb limit the file size - social.msdn.microsoft.com
Nov 13, 2019 · It is recommended to use the space usage value to predict your total workload usage; adjust this value for the expected concurrent activity and then set the size of TempDB …
USERSTORE_TOKENPERM growing very fast
Jul 15, 2019 · To me it seems like a bug, MS had such bugs in SQl Server 2008/2008 r2. I would also see amount of ad-hoc queries hitting database because that affects "userandtokenperm" …
Allocate memory to IIS or Pool - social.msdn.microsoft.com
Feb 26, 2016 · Contradicted to what you expected, IIS worker process gives best performance when it uses as little memory as possible. Feeding too much memory might be good for …
Database transaction log is full due to 'CHECKPOINT'
Aug 7, 2018 · Do you have any start-up procedure or perhaps something starts immediately after server restart and thus tempdb shows up as "Active_Transaction"? tempdb is not recovered …
A Non Clustered Index on an nvarchar field not used in Query Plan
Aug 21, 2012 · To speed up performance I created a clustered index on the column for the measure (in your case "customercode") and added all selected columns to the INCLUDE …