You might want to configure a trace to run in the background that logs expensive activity, i.e. high reads > 100,000, high CPU > 10,000, high duration > 15,000 (those...

No, I would highly doubt that the creation of the index + the copy would take as long as without the index and allowing the copy to continue. However, you...

aaron.reese (4/26/2012)

---

hi guys,

I have a table with 110M rows in it, 33 fields per row, mostly varchars of varing lengths with no clustered index (20GB)

I am copying the table to...

I can't say that I would use it for extensive work but if I needed to deal with an alert quickly or run a quick query I might use one....

You would need to write an application wherein you can establish a connection and use it for several processes. I did a quick Google search on "introduction to connection pooling"...

+1 on Michelle's scripts. This script allows for you to evaluate the index fragmentation and then, through passed in parameters, choose which...

You can also use Ola Hallengren's script for backups which will cover all or select databases.

Ah - I still remember the SQL Server on Linux joke. Have to admit it had some ideas racing in my mind. 😛

Uh,...

Your analysis is going to have to include a look at what is going on at the disk layer as well, i.e. what is the disk latency during that time....

No, you weren't coming off as arrogant. My apologies if my reply, specifically the statement about humility, seemed that I was implying such. 🙂

What you stated is really my point,...

There are times that I think I know a good bit about SQL Server and then I go to work somewhere that they use it in a different fashion than...

I think the key term that needs to be considered is "partners" and even though not highlighted as a...

Gianluca Sartori (3/15/2012)

---

Lynn Pettis (3/14/2012)

---

GilaMonster (3/14/2012)

---

Well it's one of our old friends, so are you...

That screams IO subsystem problem. 🙁