Viewing 15 posts - 29,326 through 29,340 (of 49,552 total)
Isolation level's not that relevant. The locks taken are. A single select alone should not be able to participate in a deadlock, regardless of isolation level, unless there are odd...
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
November 18, 2010 at 3:32 am
ravisamigo (11/18/2010)
What might be the issue if I can see more locks when I ran a below query.
More locks than what? Than earlier? Than you believe should be 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
November 18, 2010 at 3:12 am
There is nothing in the posted error that indicates that the restore chain is broken or that the log shipping database needs to be restored from another full backup.
All that...
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
November 18, 2010 at 3:11 am
Is it part of a transaction? Are any of those objects views?
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
November 18, 2010 at 3:07 am
virender.singh (11/17/2010)
but my boss:):-D suggested me use physical table instead
Ask him for his reasoning.
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
November 18, 2010 at 1:23 am
ps. (11/18/2010)
Only difference is it will be destroyed when u disconnect (Prefixed with #)
There are other differences internally around logging, caching when dropped and the like.
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
November 18, 2010 at 1:21 am
That's not a restore job failure message. That's saying that there has been no restore for a certain period of time. If the restore job is failing, check the reason...
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
November 18, 2010 at 1:11 am
May I suggest a google/bing search. There's a list of new features for each version in the Books Online on MSDN.
For example, the 2008 What's new is here - http://msdn.microsoft.com/en-us/library/bb500435%28SQL.100%29.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
November 18, 2010 at 1:10 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1022640-148-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
November 18, 2010 at 1:07 am
Are you saying you don't know what a deadlock is or that you don't know what objects it is on?
If you don't know what a deadlock is, do some reading,...
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
November 18, 2010 at 1:04 am
pavan_srirangam (11/17/2010)
Yes exactly its a contention on my datafile SGAM pages
In a user database?
What's the wait type you're predominantly seeing? What's the wait resource? What has led you to 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
November 17, 2010 at 10:50 pm
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
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
November 17, 2010 at 10:45 pm
There is a Microsoft Certified Architect certification for SQL Server. It's not an ITP though...
http://www.microsoft.com/learning/en/us/certification/architect.aspx
The ITP exams are aimed at people with 3 or more years experience. I would argue...
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
November 17, 2010 at 2:04 pm
SqlN00bie (11/17/2010)
As for a specialist, what type of specialist would you recommend? Database architect? Or a Database developer?
Right now I would suggest a performance tuning specialist. Someone who can...
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
November 17, 2010 at 1:21 pm
You have a 100 or so line long trigger on that table. That's part of the cause of the deadlock.
Is that trigger necessary?
Is it written as optimally as possible? Remember...
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
November 17, 2010 at 12:37 pm
Viewing 15 posts - 29,326 through 29,340 (of 49,552 total)