Viewing 15 posts - 9,961 through 9,975 (of 49,552 total)
Reducing the logical reads involves tuning indexes and query. That's about all that can be said without further information.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 20, 2014 at 12:31 am
See Chapter 4 of http://www.red-gate.com/community/books/accidental-dba for a lot of discussion of memory and some guidelines around the setting of this value.
The setting takes effect immediately, no restart is required.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 20, 2014 at 12:30 am
rodjkidd (2/19/2014)
SQLRNNR (2/19/2014)
rodjkidd (2/19/2014)
Koen just say you are a Holistic SQL Server Consultant - you'll be fine then 😀
Rodders...
Just wondering if a holistic consultant does spinal adjustments??:cool:
Jason, not sure about...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 7:53 am
A Full database backup is just that, a backup of the full database, all data files.
When restoring, unless you need to move the files to a new location it's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 7:51 am
Welcome to page 2150 🙂
It's not necessarily the easy questions that we moan about. It's the ones with no thought or no research or the ones that are unreadable or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 7:47 am
Can you run a select on the table, get the DATA_LENGTH of each of the lob columns and order by the sum of all those columns data lengths desc? Let's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 7:00 am
Are all the distincts really necessary? Is the Union necessary or will union all work?
Personally I prefer creating clustered index on a temp table before putting data into it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 6:28 am
Though not without analysis first including some work to ensure TempDB can handle the additional load.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 6:26 am
Firstly, is the cost a problem? Large is not necessarily a problem as the percentages within a plan have to add to 100%
You'll never see a key lookup caused by...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 6:25 am
From Books Online (under ALTER INDEX)
Table locks are applied for the duration of the index operation. An offline index operation that creates, rebuilds, or drops a clustered, spatial, or XML...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 6:16 am
Ooh, that's a lot of LOB columns.
Maybe an index reorganise with LOB_Compaction on?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 6:01 am
RowLock takes locks at the row level. It won't prevent lock escalation, but it will start the locks at the row level.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 5:43 am
The table is a heap?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 5:09 am
You can set them after installation, not during. They're both database level settings.
to be honest, I don't see much point in having them both on, usually one would pick one...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 5:09 am
A candidate who described himself as a database performance and recovery specialist.
Me: You get alerts that a critical database is not available and when you look in Management Studio you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2014 at 2:00 am
Viewing 15 posts - 9,961 through 9,975 (of 49,552 total)