could you please tell me what kind of drivers do I need to update

thanks

Hi,

Could you please advice me whether the following analysis would be fine or not To set Min and Max memeory values.please correct me if I miss anything.

Analysis:

In order to determine...

No, we did not add the SQL Service account in lock pages in memory.

thank you

We 16GB in the server and total 16GB is allocated for SQL Server.Still we got couple of times the below error in last two months.

A significant part of sql...

Thanks Chris,

We have the default settings for SQL Server memory.

Min: 0

Max: 2147483647MB

We have windows 2003 R2 EE x64 with SP2 and SQL Server 2005 EE x64 with SP2

I would like to know what it does..OS windows 2003 EE R2 x64 with SP2 and SQL Server 2005 EE X64

Thank You

If I change the option to reorganize pages with original amount of free space in optimization tab in maintenance plan will solve my problem?

Thanks in advance

you mean to say that do not set the page file size to 1.5 times the physical memory or do not use separate drive to keep the page file?

hi,

I followed the method2 to calculate the pageing file size, which says,Note the maximum value for the Page File Bytes Peak counter, and then multiply the value by 0.70. The...

Thank You.....

I did see the system files in The drive, they all having big numbers like ab##12 and size is in GB.

we 16GB of RAM. for this what would be the...

Volume Layout type filesystem status capacity freespace %frees faulttolerance overhead

E ...

Hi Jeff,

Iam curious to know why the available space for the database was showed as zero in enterprise manager and negative value when I ran sp_spaceused before running DBCC UPDATEUSAGE.

After...

thank you,

we have applied no cumulative updates so far. We have SQL Server 2005 with SP2 only.

I tried to get CU9, but they saying first test it and if really...

plz post your dead lock graph from the error log