Viewing 15 posts - 40,996 through 41,010 (of 49,552 total)
Can you run a checkDB on model?
Does a restart of SQL fix the problem?
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 18, 2009 at 4:55 am
free_mascot (2/18/2009)
???If database is corrept and we are taking backup.... does backup too have corruption?
Yes. This is why it's so important to find corruption early so that there are clean...
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 18, 2009 at 4:53 am
Leo Leong (2/18/2009)
i don't think this is what i want.
I don't think so either. Why are you disabling lock escalation?
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 18, 2009 at 4:48 am
lior (2/18/2009)
HiThanks for the reply
I ran the command in Management Studio and the output I got was just "Command(s) completed successfully."
Is that what you asked me to do ?
Yup. That'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 18, 2009 at 4:47 am
ALZDBA (2/18/2009)
I know (and have activate on all our db) PAGE_VERIFY at db level.Is my perception correct that this would detect any issue as soon as it occurs ?
Which...
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 18, 2009 at 4:47 am
Check the lock types taken for both. You'll probably find that the delete has taken a lower granularity lock than the update
sys.dm_os_tran_locks
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 17, 2009 at 11:35 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic659079-357-1.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
February 17, 2009 at 11:32 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic659079-357-1.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
February 17, 2009 at 11:31 pm
What's your disk layout? (No of drives, raid level, DB-related content)?
SAN or local storage?
What do the following two perfmon counters look like (broken down by drive)
Physical disk\ avg sec/read
Physical disk\...
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 17, 2009 at 11:29 pm
Aaron Gonzalez (2/17/2009)
The funny thing here is that the database is configured for snapshot replication, not for transactional replication.
Then there's some left-over, misconfigured transactional replication somewhere. Snapshot doesn't use 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
February 17, 2009 at 11:28 pm
Then set the server's max memory. You should do that anyway on a 64-bit server because of SQL's tendency to eat memory.
How much memory on the server?
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 17, 2009 at 11:19 pm
colin Leversuch-Roberts (2/17/2009)
whether you can pass one index hint i have no idea - never tried that.
You can't. Plan guides are limited to the hints that appear in...
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 17, 2009 at 2:22 pm
When you run ALTER DATABASE ... MOVE ... SQL doesn't actually move any files. If it's a user database that you've done the alteration to, you have to take...
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 17, 2009 at 2:12 pm
Please run the following and post the results.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Is that database a critical production DB that you're taking log backups of?
Are there...
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 17, 2009 at 2:02 pm
Ninja's_RGR'us (2/17/2009)
That begs this question... assuming you have a corrupt backup of msdb, can you rebuild it then reimport the data back in?
You should, providing you can get the data...
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 17, 2009 at 1:55 pm
Viewing 15 posts - 40,996 through 41,010 (of 49,552 total)