Attempting to either create a temporary table or index statitics.

Question

Attempting to either create a temporary table or index statitics.

forsqlserver

SSCoach

Points: 18902
More actions
May 21, 2009 at 5:07 am

#130411

Dear All,
I am using ss2k when I run index tuning wizard it gives error:
"The server returned an error attempting to either create a temporary table or index statitics."
One more issue is this that the database server machine getting slow after 10-15 days..yet the processer and RAM consumtion is on normal state at that time.but database response goes very slow..
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 1

I'm sure about why you getting error.

However if there is a certain query or table that you have identified as being a poor perform, throw the code at us and see what we can do 🙂

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

guptaajay1985 (5/21/2009)
I am using ss2k ...

Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Are you running this on your production server or on a dev server? (hint, you should not ever run index tuning wizard or database tuning adviser on a production system)

Does the account that you're running it as have rights to create objects in the database.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

forsqlserver SSCoach Points: 18902 More actions · Answer 4

Hi Gila,

Thanx to view the article....

Next Time I will post these questions in SQL 2000 forums in the future.

This database server is a development server.I am using the sa account.

Thanx

Thanks