Viewing 15 posts - 6,271 through 6,285 (of 49,552 total)
Grant Fritchey (4/1/2015)
GilaMonster (4/1/2015)
Crystal ball to aisle 3 please. Crystal ball to aisle 3.http://www.sqlservercentral.com/Forums/Topic1673420-2572-1.aspx
Wow. "Here's a screen shot that says the same thing I already typed. That should clear up...
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, 2015 at 5:51 am
Do you know why they implemented partitioning? What problem is it supposed to solve? Archiving/deleting of old 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
April 1, 2015 at 5:42 am
Brandie Tarvin (4/1/2015)
GilaMonster (4/1/2015)
Crystal ball to aisle 3 please. Crystal ball to aisle 3.http://www.sqlservercentral.com/Forums/Topic1673420-2572-1.aspx
Sorry. No crystal here. Just muddy, occluded glass. Would that help?
Somehow I don't think so.
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, 2015 at 5:37 am
Nope. Tells me nothing at all.
What counter, what values, what pattern? That's to start. What, other than the attached statement, are you basing the conclusion of memory pressure on?
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, 2015 at 5:35 am
Crystal ball to aisle 3 please. Crystal ball to aisle 3.
http://www.sqlservercentral.com/Forums/Topic1673420-2572-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 1, 2015 at 5:28 am
I can't see your report, I don't know what counters it's looking at and I can't see your screen. So unless you can provide a lot more details, there's little...
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, 2015 at 5:24 am
No, you won't be able to shrink the database because the log is full.
GilaMonster (4/1/2015)
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, 2015 at 5:22 am
Either fix the replica so that it is syncing or remove the availability groups, fix the root problems and reconfigure.
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, 2015 at 4:32 am
SQL Audit, SQL Trace or extended events and hope your users/developers also don't know about that trick and keep in mind that someone determined may be able to avoid your...
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, 2015 at 4:30 am
The only time that mirroring or availability groups with mis-matched versions are supported are for rolling upgrade scenarios.
If you were to set up mirroring with the SQL 2008 R2...
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, 2015 at 4:22 am
Open up Management Stdio, open the login dialog for a server, click the options button and then the 'additional connection parameters' tab and look at the free-text box there 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
April 1, 2015 at 4:13 am
You need to investigate the proc and identify what portions are performing badly and fix it. Execution plans are part of 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
April 1, 2015 at 4:11 am
karthik babu (4/1/2015)
Actually, the below site helped to get the connection source..
*sigh*
The application name passed to SQL can trivially be spoofed, so the app which the connection says it's coming...
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, 2015 at 3:51 am
What, exactly, do you mean by 'excessive paging'?
Disk queue length is a useless counter, it tells you nothing of value.
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, 2015 at 3:46 am
Look at SQL Audit, extended events or SQLTrace.
That said, it's trivial for the program name to be spoofed on connection, so what the connection says it's connecting from may...
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, 2015 at 3:38 am
Viewing 15 posts - 6,271 through 6,285 (of 49,552 total)