Ratheesh.K.Nair (10/15/2014)

---

I have got around 130 trace files now.

In between the CPU came down to 13 at 7:54 and back to 95 again i have trace in between those times.

Can...

A proper profiler-to-local-disk script can be run to capture heavy CPU users with very little overhead on the system. I have run my very tight collection of fields/events on...

Parameter sniffing is almost certainly the cause. And there isn't much you can do about it. Data value skew can cause unbelievably bad performance if you don't do...

Is B.Country_Area an Nvarchar field by chance? If so, try N'EUR' in your CASE statement.

Also, get the FULL XML QUERY PLANS from both executions and run them...

If this is a test/learning environment you can do just about anything you want with it, including using just one network for everything, doing the shared storage via the domain...

Paul White did a very nice blog post about Halloween Protection and schemabinding on UDFs. That is a significant performance improvement.

I don't know the answer to your...

Try your XML method under stress and see how it holds up. Or with lots of rows.

There are some very nice threads here on SSC.com about string...

1) POTENTIAL is just that. It isn't guaranteed, or even likely in some scenarios....

sqldriver (10/6/2014)

---

If you're tasked with debugging/troubleshooting?

Specifically:

Assigning workable values to parameters/finding out where they're passed from or stored

Heavy use of temp tables/table variables/real tables that get truncated

Verifying results

Bonus points if it's...

Normal backup schemes (full/diff/tlog) work just fine for mirrored databases. The mirroring system won't let stuff get removed from the tlog if it isn't yet hardened over on the...

I wonder if it is page compression at issue here. Unless you are getting a MASSIVE amount of regular insert/update/delete activity with this table the VAST majority of data...

Ratheesh.K.Nair (10/1/2014)

---

Hi experts,

Is there anyway to check if server is having disk latency or IO issues?

Found below in SQL error log

Date10/1/2014 8:28:58 AM

LogSQL Server (Current - 10/1/2014 12:00:00 AM)

Sourcespid10s

Message

SQL Server...

By "offline" I assume you meant "not readable".

Well, those were my two items. I look forward to your finding and posting about a root cause. There...

If you come up with something let me know!! 🙂

Indexing is a HUGE topic, both in breadth and depth. The best answer is that to be optimal you put on all the proper indexes that give you the...