Hi
In the last few days we have been experiencing serious performance problems with a database on SQL server 7. Query/ Update & Backup times have been increasing exponentially. ( Backup from 1 hour to 13 hours etc). There has been no radical increase in the amount of data being loaded into the...
Hi
we just had 9/10 indexed views appear on the system called _hypmv_nn which managed to lock critical files in our overnight. did you get any further with your investigations...I wonder given the naming if they were generated by a Hyperion/Brio application?
Thanks dakota81
Pointing back to itself worked, but not just to the disc, you had to point to the office folder on the installation disc and then it worked, excellent
:o)
Hi
Any thoughts on this one? We recently added a password to user SA on a server(server a) which previously had none (null). We had another server(server b) set up with this server as a linked server, but failed to change the sa password on the properties of the link on the other server. This...
I have just upgraded my pc from ME to XP( clean install) , and have tried to re-install my office '97. I get a message telling me this is an upgrade and I need some qualifying software to complete the installation. I am fairly certain this is not an upgrade, but how can I tell. I had no trouble...
Thanks for the post,
I checked the fragmentation and the scan densities are all as close to 100% as makes no difference. Likewise I just rebuilt all the indexes. In fact these are aggregate tables and I had only just rebuilt them data and all. To insert all the rows into both tables took only a...
Hi
I have a problem with sevral update scripts having massively increased in run time :
The scripts updates one column on a table by joining to another table of the same size and then joining to another smaller table the following is an example:
UPDATE AGG_10_TT_DATA
SET PUB_ISBN_CHECK_SUM =...
Hi
I am looking at putting in place a backup strategy that will allow a rapid switch back to yesterdays position, and would welcome any comments.
This is the situation:
I have a large ( 150gb) multifile database which is updated by a batch job once a day. If there is a problem with the...
Thanks for the feedback, I will let the system auto update the statistics for the time being and see how it gets on. I don't think this will cause a problem elsewhere as I have 10-12 other tables of the same size (this table is one of a number produced by splitting a very wide table down into...
A query which we run daily for the last two months and which took 3-4 minutes has over the last week jumped to a 33 minute run time. When the query was run the system was not working particularly hard and most of the rest of the system was performing OK. I pinned it down to a particular table...
Hi
We had a similar problem in our app. Our solution was to create a user access table based on the BOUSER name. On each table we wanted to secure we added a self join looking up the relevant value on the table keyed by the @Variable(BOUSER)
e.g. table1.testvar in (select testvar from...
You can generate the script for creating the database and all the objects in it via Enterprise Manager (highlight database, right click, all tasks, generate sql script). This will offer you a dialogue box in which you can select the items you want to script, click the "show all" button...
Hi
I have a query which runs in about 7 minutes, when I add another column from a simple (small) lookup table joined to one of the other tables already in the query the query time drops to 2 minutes. When I examine the query plans for the two queries the major difference is that the faster (but...
I don't have a copy of 7 running to give you an actual example but you can use an Execute Process Task to run the DTSRUN utility. This can be used to run a DTS package, the same as if you called it from the command prompt or from a JOB step.
Examples( from books on line)
To execute a DTS...
Thanks for the info. I thought that was probably the case but couldn't find any documentation to confirm it. The Job does normally run on Sunday morning when the system is idle but on a couple of occasions has hung up on a lock and so has only been part done on Monday morning. I am putting in...
I have a weekly database maintenance job which amongst other things rebuilds all the indexes, this job takes about 8 hours & so if it is still running during 'up' time it has a major impact on the users.
I'd like to be able to quit this job if it overruns or at least be able to give users an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.