To add to what Grant says - "generating" a baseline from a point in time is often useless. My recommendation is to use a monitoring tool and gathering metrics over...

A 30 hour rollback kind of makes me think something was using explicit transactions and not committing them and held a connection for a long time. Had that happen on...

To me that sounds like you are using a newer or older version of report builder than the server expects. I would uninstall report builder from your machine, download it...

To add to the question on losing a connection that may be in a transaction,

We have had site down maintenance and to where the network is just brought down....

• This reply was modified 1 year, 5 months ago by Mr. Brian Gale.

Something to note - if you HAVE indexed views in place, you can update your queries to use query hints in Standard that will use the indexes on the view....

I agree with ratbak here. But I would also like to point out that with so few data points, the estimates are going to be a bit off. But eyeballing...

Possibly a silly question but did you set up the SPN's when you installed the new instance?

Correct me if I am wrong, but isn't the error a login related issue, not a database related issue?

To me it sounds like the server cert is not recognized or...

I think it really depends. Do you know that your disk is going to be the bottleneck? I mean, your approach would make sure the disk is not the bottleneck,...

Sounds to me like the certificate chain to identify the server is not valid. This sounds like an SSL issue. I'd reach out to the server team and make sure...

I would also like to add that tools will give you a benchmark of how the server performs under load. This is a good benchmark, but if your server doesn't...

I'm a mix. SOMETIMES I want silence when I work, sometimes I want music. It depends on the day.

But on average, I prefer music over silence. When I do put...

I would not recommend "multi-processing" the...

Probably a dumb question but did you restart the services after installing the filter pack AND did you install the filter pack on the server (not your local machine)?

Not trying...

You can do this however you like. It's your system. You want it batched? then write your code to batch it. You want it to capture failures, toss in some...