Viewing 15 posts - 7,621 through 7,635 (of 49,552 total)
Stamey (10/3/2014)
Here are three images. Is this what you need?
No, or I'd have asked for pictures of the deadlock graph 😉
https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/
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
October 3, 2014 at 5:33 am
Re-do the secondary from a fresh backup
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
October 3, 2014 at 3:06 am
Stamey (10/2/2014)
What do you expect here?
The deadlock graph, the entire thing. Without being able to see exactly what objects, indexes, locks, statements, etc were involved in the deadlock, it'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
October 3, 2014 at 3:03 am
nm.
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
October 3, 2014 at 2:59 am
john.petrey (10/2/2014)
I am using sys.dm_exec_query_stats summing the Physical and Logical Reads. Is this a viable option for gathering this metric?
No. That DMV shows the total logical reads...
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
October 3, 2014 at 2:56 am
Yes... By doing nothing.
Go have a look at the sysdiagrams table. Are there any columns in there that have a collation defined at all?
Hence why I'm wondering why someone has...
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
October 3, 2014 at 2:51 am
farzad.jalali (10/2/2014)
GilaMonster (10/2/2014)
Why do you need to?it's a task's requirement which is assigned to me .
Ok, why reason did the person assigning to have?
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
October 2, 2014 at 7:37 am
If you're already having capacity problems, then consolidation is probably not a good idea. Consolidation is great for when you have multiple databases on different servers and those servers 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
October 2, 2014 at 6:41 am
Can you post the deadlock graph?
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
October 2, 2014 at 6:35 am
Why do you need 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
October 2, 2014 at 5:29 am
doug.davidson (10/1/2014)
step 3: Truncate Transaction LogDBCC SHRINKFILE (N'X_log' , 0, TRUNCATEONLY)
Firstly, the comment is wrong. That doesn't truncate the log. The TruncateOnly option is only valid for data files, it'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
October 2, 2014 at 2:42 am
And how many rows are in that 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
October 2, 2014 at 2:23 am
That's a .Net error. What were you doing when you got 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
October 1, 2014 at 7:56 am
enriquemallon (10/1/2014)
Today I was trying to attach a database in SQL server 2008 R2.
Databases cannot be downgraded, you need to attach it to SQL Server 2012 or SQL Server 2014
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
October 1, 2014 at 5:46 am
What do you mean 'one table takes time to execute'?
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
October 1, 2014 at 3:07 am
Viewing 15 posts - 7,621 through 7,635 (of 49,552 total)