Can you try to rebuild the index and run the process ?

You can run  a trace and then look into the trace to find out who ran what queries.

If you want to use anonymous access in IIS and use windows authentication, change the user which IIS uses to connect to the server to a valid windows user which...

Reads is one of the major factors which will impact the execution time of the query

You can use the following also to give you more information about what specific table...

Couple things which you might want to consider for the future are.

1) have an additional HBA card. We have 100 MBPS HBA cards and for huge databases it used...

Re-indexing all the tables on all the databases might be an overkill. You might want to re-index tables which are highly fragmented. I had a script for that somewhere and...

You cannot do that. When you open SQL server, the databases are listed from Sysdatabases on which public user has select access.

are you referring to clustered SAN or multi-pathing. We run multi pathing software(Powerpath from EMC) with SQL server on our clustered servers without any issues.

In either case do consider that...

Book online says.

When both instances are first started, they typically acquire 8 MB to 12 MB of memory. As users connect to the instances, each instance acquires enough memory to...

There was a bug where if you are running a perfmon trace and you re-start SQL server, perfmon counters will not be visible. The trace needs to be stopped when...

What is the value of max server memory ?

We saw this error on our database server against which a huge query was run simultaneously from 9 different servers. The query eventually updated the application server cache. We had SQL hang after...

'A separate RAID-10 array is usually not an appropriate choice for the transaction log'.

I believe this recomendation is for VLDB's and is for optimum cost to performance ratio. But it would vary...

Below is an alternate procedure to grant permission to all procedures. You can create a role called Execute_storedprocedure in model database and whenever you create a new database, execute the...

I have seen many threads on this site stating performance issues with NAS. But if it is only during re-indexing you are having problems, you might want to break down...