run it about every 5 min,,,that should be plenty.I run mine often send it to csv file. then export to excel

Just make sure you run it from a non sql...

I believe I tried that for the same reason and I had no luck. I created a job that has 2 process

then I can schedule it for off hours.Then you...

correct you need to fail the nodes over to the primary cluster( or right click and use change groups) via the cluster administrator, make sure all the resources are running,...

hard to tell what is causing it....we need more info

1.whats the DB size

2. how much Ram

3. slq server setting min and max --- this is so that the OS...

you should double check on the upgrade path as far as I am aware it does not exist, in order to update you need to detach/reattach.. so you will need...

If you have above 100 pages, a non lcustered index(not a heap,casue u cant fix this unless you add a clustered index) frag is above %30 then rebuild that index....

looks like a number of issues going on...by guess,

1.st you have many heap tables.these are fragmented, you need add a clustered index in order to fix.

2. do an order...

Chances are the Db integrity was designed on the front end...so you dont have anyone to ask I would try the developers....I have a number of DB that dont have...

I believe Grant is telling to run the following, which will link a SQL statement up the you xml plan, this will allow you to look at the plan...

my best suggestion is to run the following

select * from sys.indexes

Then get the index id that you are looking for, run profile trace and filter on index id.

You...

Thanks Matt both Great points. I was aware of them both but had not thought about it

Seems that the cluster index is composite but looks like I can drop...

cool I was interested in this

"Deleting doesn't control what pages will be reused or not. That's going to depend more on the inserted data's relationship with the clustered index."

we often...

chances are you have diff problem, if you DB is only 260 mb then fragmentation is more ten likely not your problem. Sql you should be able to handle that...

2 things.

1. what is your page life expectancy, should be around 300 plus. meaning a page is staying in cache for longer then 5 min.the higher the better, that number...

Thanks.....GRANT, that helped