george sibbald (4/15/2011)

---

as I do not seem to be trusted - from a 'trusted' source 🙂

http://technet.microsoft.com/en-us/library/ms188388(SQL.90).aspx

in the maxdop section -

'Parallel index operations are available only in SQL Server 2005...

But I can't imagine that microsoft limit the processors on index rebuilds but if you say so. However I would test it. But by the way, I have noticed that...

You'r right. Here is the evidence from a "trusted" source ... 🙂

http://msdn.microsoft.com/en-us/library/ms143760%28v=SQL.100%29.aspx

Hi,

it is the same value in sql server and in system monitor. Only if in the sys view with the performance counters a counter exists with a base ending, you...

@alzdba: But could this be the reason if the sql server has performance issues? The server has 7 GB free physical memory.

No, usually not.

Have you checked the disk performance of the sql server? Wait time? Read/Write Bytes / sec? Reads/Writes / sec?

So we should be sure what the source of the...

First, has sql server the AWE flag enabled although it is a 64-bit machine?

I have looked at the results:

Target Server Memory and Total Server Memory is the same -> that's...

Hi,

tell me about the server? what server is it? Are some other services running on this server? what storage the server use? Is it virtualized? Are there running other databases...

Thanks Grant. We can't learn enough ... 😉

That's true, this would be also an indicator. Thanks Craig.

You can take the following statement:

selectcntr_value as [PageLifeExpectancyInSeconds]

fromsys.dm_os_performance_counters

whereobject_name like '%:Buffer Manager%'

and counter_name like 'Page life expectancy%'

If the value falls below 300...

Sounds mysterious ... 😎

In nearly all cases the disk is the bottleneck and if you set up a replication to a database which is located on another disk it would really increase the...

But you haven't seen any errors in the event log?

ramanan_iyer (4/13/2011)

---

Hi Patrick,

Thanks again for your prompt response.

I have some experience with SQL Replication around 5 years back, thanks for the hint will do a trial again.

We have transactional replication...

Yes, if you only want to take a copy of these 2 tables you can use replication (the best fit in your case would be a transactional replication). In this...