Viewing 15 posts - 32,806 through 32,820 (of 49,552 total)
You cannot kill a rollback.
You could try restarting the instance if you think the rollback is stuck. Beware, the rollback will continue after the restart, while SQL's bringing the DB...
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
May 20, 2010 at 4:54 am
It probably would be better to have the cluster on a more unique column. Without analysing the system I couldn't say for 100% sure.
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
May 20, 2010 at 3:12 am
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
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
May 20, 2010 at 2:21 am
Please post table definitions and index definitions, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
May 20, 2010 at 2:18 am
Yang-703993 (5/19/2010)
GilaMonster (5/19/2010)
Do you have a reason to think the size of the system tables is adversely effecting DB performance?
I think this application is not creating hundreds but thousands tables:Wow:,...
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
May 20, 2010 at 12:40 am
CirquedeSQLeil (5/19/2010)
GilaMonster (5/19/2010)
Do you have a reason to think the size of the system tables is adversely effecting DB performance?
My inclination would be that the 100's of tables added daily...
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
May 19, 2010 at 2:25 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/FindPost924105.aspx
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
May 19, 2010 at 2:20 pm
Do you have a reason to think the size of the system tables is adversely effecting DB performance?
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
May 19, 2010 at 2:13 pm
muten79 (5/19/2010)
We are doing backup of the drive which contains the database every day, and we'll do one before starting the migration.
That's not the way you back up a SQL...
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
May 19, 2010 at 1:27 pm
Not really that well hidden.
SELECT * FROM sys.objects WHERE type = '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
May 19, 2010 at 11:59 am
CirquedeSQLeil (5/19/2010)
The system tables are in the hidden resource database where access is limited.
The definitions for many system views procs and functions are in the system resource DB, but 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
May 19, 2010 at 11:24 am
I believe it is cleaned when the database closes, hence take the DB offline and bring it online and it should be cleared.
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
May 19, 2010 at 11:10 am
There's a profiler event that gets fired when SQL removes a plan from cache.
Checking....
Performance: Performance Statistics
Indicates that a compiled plan has been cached for the first time, recompiled, or evicted...
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
May 19, 2010 at 11:10 am
r.rozeboom (5/19/2010)
Iam MCTS sql2005. and want to upgrade towards MCITP2008.
There's no upgrade path from MCTS 2005 to MCITP 2008. The upgrade that's available is from MCITP 2005 (either dev 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
May 19, 2010 at 10:53 am
Swirl80 (5/19/2010)
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
May 19, 2010 at 10:52 am
Viewing 15 posts - 32,806 through 32,820 (of 49,552 total)