you dont need an extra license if sql db engine and ssas are active on the same node. you can have them in different resource groups.

problem is that you can...

an extra clustered ssas would require an extra license. thats what i was told.

well let me rephrase the question. how do I tell which query is eating up all the free pages?

thanks

I am not sure how is this useful.. may be I am missing something. I get a result of 5001 from first query. When I use that in second query...

Actually that was it. I had the wrong db id in there.

Thanks so much. I totally forgot about that parameter.

I do have some filters. I am running exact trace in production and dev. here is my trace definition:

/****************************************************/

/* Created by: SQL Server Profiler 2005 ...

Ran it again and it worked:

DBCC PAGE('test',1,1230531,3) WITH TABLERESULTS

GO

here is what I have.. but I don't think it tells me anything.

BUFFER:BUF @0x0000000244FD1600bpage0x0000000244458000

BUFFER:BUF @0x0000000244FD1600bhash0x0000000000000000

BUFFER:BUF @0x0000000244FD1600bpageno(1:1230531)

BUFFER:BUF @0x0000000244FD1600bdbid110

BUFFER:BUF @0x0000000244FD1600breferences0

BUFFER:BUF @0x0000000244FD1600bUse17211

BUFFER:BUF @0x0000000244FD1600bstat0xc00109

BUFFER:BUF @0x0000000244FD1600blog0x21597979

BUFFER:BUF @0x0000000244FD1600bnext0x0000000000000000

PAGE...

tried this:

DBCC PAGE('test',110,1230531,3) WITH TABLERESULTS

GO

but doesn't really work

Thanks much. Greatly appreciate it.

Most important thing here is that it needs to happen NOT at the record but employee level. I am not sure a trigger can handle this.

well the problem is that my requirement says I need to archive the old records and insert new records if any change occured. and it needs to happen at the...

I need to able to do this at the employee level. so even if a single field is updated in prod or is different from what I have in staging...

what other information would you like me to provide?

there are triggers on the table and isolation level is read committed.

how does that impact log shipping?