Viewing 15 posts - 16,366 through 16,380 (of 49,552 total)
Add more drive space. Something that runs over the weekend clearly needs extra log space (probably index rebuilds), so shrinking is not going to help you at all, it just...
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
September 30, 2012 at 3:18 am
You said you want to shrink because your backups are taking too long. Shrinking will not reduce the duration of your backups.
How big is that DB? How long will 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
September 30, 2012 at 3:17 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
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
September 29, 2012 at 1:35 am
One other point... Fragmentation will not affect whether a query plan uses a seek or a scan, because the optimiser does not take fragmentation into account.
Low page density however might...
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
September 29, 2012 at 1:33 am
Boris Pazin (9/28/2012)
Shrink job is running before the re-indexing job. That is not good.I suppose it should be database shrinking first, re-indexing after, right?
No, it should be reindex only, never...
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
September 29, 2012 at 1:32 am
The design of indexes of clustered indexes to prevent fragmentation isn't entirely (or sometimes even mostly) about preventing fragmentation. It's also about preventing page splits, which can be pretty nasty...
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
September 28, 2012 at 2:36 pm
No.
The only way to 'give' an exec plan to a query is using the WITH PLAN hint, it requires the XML form of the plan. SQL 2000 does not give...
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
September 28, 2012 at 11:20 am
Potentially, but I suspect it's more likely to be queries. The restart will clear the cache, so if you've got inappropriate plans being cached, the restart will 'fix' the problem
See...
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
September 28, 2012 at 11:18 am
If more than about 1% of the rows will be returned, SQL won't do key lookups, it'll revert to a scan.
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
September 28, 2012 at 11:16 am
It it's only returning 10 rows I wouldn't worry about the key lookups to be honest.
Key lookups are nasty, but on 10 rows it's not a huge overhead.
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
September 28, 2012 at 10:33 am
How many rows does the query return? How many in the table?
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
September 28, 2012 at 10:09 am
sql-lover (9/28/2012)
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
September 28, 2012 at 9:49 am
Perry Whittle (9/28/2012)
GilaMonster (9/28/2012)
DBCC CheckDB
DBCC CheckCatalog
If neither return an error, take a backup, restore that backup on the SQL 2008 instance. Then the...
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
September 28, 2012 at 9:40 am
There will never be a situation where a server has no locks at all.
What locks do you have and why are they a concern?
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
September 28, 2012 at 9:19 am
First, run these on the SQL 2000 database
DBCC CheckDB
DBCC CheckCatalog
If neither return an error, take a backup, restore that backup on the SQL 2008 instance. Then the two commands Perry...
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
September 28, 2012 at 8:49 am
Viewing 15 posts - 16,366 through 16,380 (of 49,552 total)