Dear Anoop,

How many tables do u have in ur database and which table has the higest row count.

from

Killer

Hi,

Total no of records in a table

select count(*) from tablename

Total number of records in a database

For userdefined table

SELECT

    [TableName] = so.name,

[Table id]=so.id,

    [RowCount] = MAX(si.rows)

into #Temp1 FROM...

Hi,

Processors enabled with HTT share more resources (for example, execution resources) on the same physical processor than do multiple-core processors. For example, multiple-core processors have separate...

Hi,

We have few deadlocks but they are normal per navision documentation.

i am trying to looking in other areas and let u all know.

from

Killer

Hi ,

HTT is set to OFF.

Pls help in this regard.

from

Killer

Hi,

Do ur 6th text file has a date field or binary text.

HTH

from

Killer

Dear Michael,

It is impossible to schedule a job in sql server to restart SQL services

U have to create a batch file which will restart ur SQL Services.

u can use net...

Hi Vik,

I will check for HT and let u know .

from

Killer

Hi,

Thanks for all ur help .

The application was slow before the client purchased the new server but the old server have only 6 GB of RAM.

Now the server have 32...

Hi,

AWE is enabled and stopped and restarted the sql services.

from

Killer

Hi,

As this time ur datafile size is 3 GB so u can go for 3 or 4 times backup a day.

or u can do one more things

create a standby...

I too agree with steve.

Hi,

In what u are Good ?

Yes ,We have number of tables in buffer (memory) but that is our need because these tables are used number of times most freq.

But they have only few records as...

Hi,

AWE option is enabled . Yes there are few locks on the tables but that is normal for our application.

We have enterprise edition and we have setup dynamic memory allocation.The CPU utilisation...