Viewing 15 posts - 6,271 through 6,285 (of 49,571 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...
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?
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.
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?
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
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...
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)
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.
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...
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...
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...
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.
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...
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.
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...
April 1, 2015 at 3:38 am
Viewing 15 posts - 6,271 through 6,285 (of 49,571 total)