Viewing 15 posts - 40,036 through 40,050 (of 49,552 total)
You'd restore the backup of master that you have from Server A. The fact that you have a second server is immaterial.
http://msdn.microsoft.com/en-us/library/ms190190.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
April 2, 2009 at 7:17 am
The full procedures please (both of the ones involved in the deadlock), plus table structure and index definitions. If you can post the deadlock graph (produced by traceflag 1222) as...
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
April 2, 2009 at 7:09 am
Probably means that SQL went down or hung at 1:13.
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
April 2, 2009 at 7:08 am
sbvenkatesh77 (4/2/2009)
We checked in the Windows Applicaton Event Viewer....
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
April 2, 2009 at 4:05 am
Without seeing the queries in question, the only advice I can give you is to ensure there are no unnecessary commands within the transactions, ensure that your queries are as...
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
April 2, 2009 at 4:03 am
Did you run the 'update usage' that the kb article refered to?
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
April 2, 2009 at 3:51 am
Paul White (4/2/2009)
Not so sure. The article you wrote simply shows that a range seek/scan can cover all the rows in a table. Well, yeah 😉
I was challenging...
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
April 2, 2009 at 3:49 am
Paul White (4/2/2009)
A scan may be a scan of any part of an index, which involves...
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
April 2, 2009 at 2:39 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic688600-338-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
April 2, 2009 at 2:28 am
Grant Fritchey (3/27/2009)
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
April 2, 2009 at 2:26 am
sunny Brook (4/1/2009)
First of all, to PREVENT this from happening gain, please PUT the DBs into FULL recovery mode and Schedule Regular Transcatinal LOG backup.
Full recovery is not going to...
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
April 2, 2009 at 2:26 am
David Rueter (4/1/2009)
CREATE PROCEDURE spTest
AS
BEGIN
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
--We expect isolation level to be READ COMMITTED
...do something...
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
April 2, 2009 at 2:19 am
It sounds like you have intermittent IO errors. Are you seeing any errors in the SQL error log or the windows error log?
SAN or direct attached storage? Raid level?
If I...
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
April 2, 2009 at 2:17 am
suhasini.m (3/27/2009)
2. What does Scan Count exactly mean. And howz it related to IO.?
The scan count is actually not that useful. It should indicate how many times an object 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
April 2, 2009 at 2:05 am
ebenraja (4/1/2009)
Let me know the ways to find if the tables are corrupted as if i run the check command the server restarts.
What is the exact command that you 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
April 1, 2009 at 4:50 pm
Viewing 15 posts - 40,036 through 40,050 (of 49,552 total)