It sounds like you need to carry out a generic performance tuning exercise on your platform.

Take a look at the Brent Ozar's site for an overview of the steps to...

What are the max and min memory settings for this instance of SQL Server?

I assume the max has been set to 10GB?

Keep in mind that...

This cannot be determined from the information you have provided alone.

SQL Server is currently using 10GB based on the information provided.

How much memory is...

Sounds quite possible and natural for the activity you are describing. Are you actually experiencing poor or reduced performance as a result of the fragmentation?

That said, 15 indexes does sound...

No, SQL Server is behaving exactly as it has been asked to.

The Target Server memory is the amount of memory that SQL Server has been asked to operate to.

The Total...

Hi,

I would think that it depends on the activity/process performed within the stored procedure.

For example, if you are performing some form of select statement, perhaps to generate a report, then...

Malcolm Daughtree (5/13/2009)

---

Please correct me if this is incorrect but, there are two types of index Maintenenace

1. rebuilding an Index and;

2. Re-organizing an Index

And the difference...

duly noted, thanks.

Lynn Pettis (5/13/2009)

---

John Sansom (5/13/2009)

---

Hi,

This of course does not work, unless the folder structures are in place on the system in question. Otherwise errors of the form below are returned.

Msg...

Hi,

This of course does not work, unless the folder structures are in place on the system in question. Otherwise errors of the form below are returned.

Msg 5133, Level 16, State...

Hi,

Check the status/history of the log shipping restore job (usually called something like ls_restore) for specific details as to why the restore process has failed/not completed.

This sounds like a secuirty configuration issue with your application or IIS.

Your ASP.net application is trying to connect to SQL Server using one of the builtin windows accounts rather than...

Hi,

As the prior poster mentions, you need to identify the source of your performance woes. Only then can you troubleshoot and optimise performance.

Take a look at the SQL Server Perormance...

Index maintenance can be a little trickier on a reasonable sized OLTP database if you are working with the Standard Edition of SQL Server, as the online option is of...

Hi,

Take a look at the following article[/url], it contains a reference to one of the best index rebuild scripts there is. When the stored procedure encounters a partitioned index, it...