Viewing 15 posts - 11,941 through 11,955 (of 49,552 total)
33 slides for 3 hours. Should be enough.
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
August 26, 2013 at 12:41 pm
Use 1222. 1204 is legacy, for SQL 2000 and before. Less info, harder to read, much harder to debug.
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
August 26, 2013 at 11:21 am
Also watch out for large file copies and make sure you're running updated drivers for RAID/storage.
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
August 26, 2013 at 10:28 am
I didn't say they're the best thing out there. Just that they're not useless (which many say they are)
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
August 26, 2013 at 10:27 am
Both of those covered in the 'considerations for nonclustered indexes' section.
One more added - Indexes with a leading bit column are useless
Edit: and another - Optimiser's choice of seek/scan is...
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
August 26, 2013 at 9:49 am
In that case you need to figure out what is requesting memory from Windows such that it's paging SQL out. It'll only do that if it is under memory pressure...
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
August 26, 2013 at 9:20 am
Koen Verbeeck (8/25/2013)
GilaMonster (8/25/2013)
What's your favourite index-related myth?Clustered index sorts on physical level.
Definitely will address that one, along with the related 'nonclustered index sorts physically', since they are pet peeves...
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
August 26, 2013 at 8:28 am
Andy sql (8/26/2013)
The MSSQL Maximum Server Memory is set to 29,696MB (29GB, leaving 3GB free for the OS)
That's a little high. On a 32 GB server, I'd probably be looking...
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
August 26, 2013 at 8:22 am
Sequence objects are new in SQL Server 2012, if that's what you mean.
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
August 26, 2013 at 7:50 am
kapil_kk (8/26/2013)
Koen Verbeeck (8/26/2013)
Regarding the script you posted (while I was typing my previous reply), you don't use the INSERTED or DELETED system tables. Those might come in handy.
is 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
August 26, 2013 at 7:29 am
So the current list is:
No need to index small tables
No need to index tables that fit into memory
Indexes enforce physical order of data
Seeks are better than scans
Clustered index seek/scan is...
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
August 26, 2013 at 6:49 am
Procedure cache is the old name for the plan cache.
Plan cache - cache of compiled query plans so that the optimiser doesn't have to regenerate them
Data cache - cache of...
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
August 26, 2013 at 6:47 am
Grant Fritchey (8/26/2013)
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
August 26, 2013 at 6:38 am
It's called triggers and audits, along with properly configured security (minimal permissions)
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
August 26, 2013 at 3:59 am
CheckDB creates a hidden snapshot to run against, to allow it to have a transactionally consistent view of the database. That's just the LSN that the database was at when...
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
August 26, 2013 at 3:24 am
Viewing 15 posts - 11,941 through 11,955 (of 49,552 total)