Thanks

I've been using the following script to identify the highest IO intensive queries

SELECT...

The application that uses this SQL Server is installed on the server as well and is very resource intensive

GilaMonster (1/12/2013)

---

Yes.

Adding indexes is useless if the problem is in the...

Thanks

Thanks, I know that there are definately some queries hitting the disk quite hard, and that could definately do with some tuning.

In your opinion, what's a better approach: Changing the...

Thanks

I've checked the highest averaging IO queries in cache and there are definately some serious scans happening against the top tables

Also, do you think that the low Buffer cache hit...

At startup there a quite a few inserts that run.

I wasn't sure if that would get the log to it's tipping point and then subsequently grow. Was really trying...

Thanks, would you recommend it though?

Am I right in that the 3rd phase (Undo) is where the uncommitted transactions...

Maybe something like this

SET ROWCOUNT 20000

DELETE from ....

OUTPUT DELETED.* into ........

SET ROWCOUNT 0

Not sure about the running total

Perry Whittle (1/2/2013)

---

what is the exact version of your sql server instance?

There was a small bug with the shared tools install on a cluster, you would install the new instance...

opc.three (12/21/2012)

---

SQLSACT (12/21/2012)

---

I think I figured out why this happens though - Looking at the transaction log using fn_dblog, I see LOP_MODIFY_ROW operations on the clustered index, LOP_DELETE_ROWS on the...

WolfgangE (12/21/2012)

---

hi SQLSACT,

23 Indexes seems to very very very much for a simple log table. I personally think it's very much for any table. You should check the sys.dm_db_index_usage_stats() too....

Hi Guys

As far as I know, the table is used as an event logging table and is used only used for inserts

Also, I have rebuilt all the indexes (23 in...

SQLSACT (12/19/2012)

---

Hi All

Some DDL

--Table 1

CREATE TABLE [dbo].[Indexing2](

[Col1] [int] IDENTITY(1,1) NOT NULL,

[Col2] [int] NULL,

[Col3] [int] NULL,

[Col4] [int] NULL

)

--Indexes

CREATE UNIQUE CLUSTERED INDEX [CX] ON [dbo].[Indexing2] ([Col1])

CREATE NONCLUSTERED INDEX [NCX] ON [dbo].[Indexing2]...

anthony.green (12/19/2012)

---

Sample data would be good as well

Using the following sample data

insert into Indexing values (199),(200),(210),(220),(230),(240),(250),(251)

insert into Indexing2 (Col4) values (199),(200),(210),(220),(230),(240),(250),(251)

I get no duplicates and now stream aggregate, the only...

anthony.green (12/19/2012)

---

Sample data would be good as well

Using the following sample data

insert into Indexing values (199),(200),(210),(220),(230),(240),(250),(251)

insert into Indexing2 (Col4) values (199),(200),(210),(220),(230),(240),(250),(251)

I get no duplicates and now stream aggregate, the only...