Viewing 15 posts - 6,811 through 6,825 (of 49,571 total)
paul.farnell (1/12/2015)
8000MBHow does that logic work then ?
The size of a database is the sum of the size of all data and log files it has.
One data file of 20...
January 13, 2015 at 1:41 am
There's no such thing as a 'row index' in SQL. Did you mean an identity column? Something else?
January 13, 2015 at 1:34 am
2*network latency *per transaction*, which results in locks being held longer, which can cause blocking problems, etc, etc, etc.
January 12, 2015 at 7:01 am
There could also be some effects from the write latency if the log file on the mirror is slow.
When you have synchronous mirroring, the minimum duration for a transaction is...
January 12, 2015 at 6:45 am
And don't use the Profiler GUI.
January 12, 2015 at 6:16 am
January 12, 2015 at 6:06 am
Benki Chendu (1/12/2015)
Within...
January 12, 2015 at 4:41 am
Edition downgrades are possible for a database. It's version downgrades that aren't
However it's not something you can do by running the installer and selecting a different version. You will to...
January 12, 2015 at 4:31 am
Jeff Moden (1/11/2015)
If you have a 1.3TB database running on SQL Server 2000, I'm thinking it's time to bite the bullet, upgrade the server, and upgrade SQL Server.
I'd second this....
January 12, 2015 at 3:43 am
Then statistics had not been updated since data had been added to the table.
January 9, 2015 at 7:22 am
No. But if you're trying to tune overall workload, looking at just connections is not going to give you sufficient information.
January 9, 2015 at 6:06 am
That's not tracked by default. You'll need to implement some form of monitoring or auditing.
But if you're trying to track performance, looking at connections isn't necessarily the way to go....
January 9, 2015 at 5:28 am
You're looking for current sessions which have been connected a long time, or every single connection which has been made since a particular date?
January 9, 2015 at 5:13 am
Viewing 15 posts - 6,811 through 6,825 (of 49,571 total)