yes I have database data files and tempdb on same disk... Do you think I should put tempdb (data file and log file) on a specific disk ?
Hello, Business is actually accessing a SQL Server (SQL Server 2000 SP4) but I encounter a performance issue. I found that the array where are...
Hello, each morning a stored procedure is run as a job sql. It can be very fast (1h00) or then very slow (7h00). It should be known that volume is...
Ok i understand the way it runs. Business Objects is used through ODBC driver so is there a way to change the kind of cursor ? Do i have to update...
thanks for you answer. we use SQL 2000 Enterprise Edition, so we don't have the 2GB limit. And the instance are not upto latest SP... (i am new at...
In fact the cpu is around 90% all the time <img src='/community/emoticons/emotion-6.gif' alt=':(' /><br /><br />We use two replication software to...
Ok i won't kill them. How can I see the relatime cpu use for a process ?
yes you are right this is cumulative. I've just made a try and BO users who try to connect and who have an timeout or another error create a process...
it depends... sp_unprepare;1 (use xxx cpuTime) sp_prepexec;1 sp_cursorfetch;1 so system processes... but why are they sleeping ? Why do they use...
Hello, we are having cpu troubles on our SQL Server and i try to see why... So the is Sql Server is used for Business Object. I executed a query on...
I forgot to tell you that the version of SQL SERVER is 2000 EE and the system is under Windows 2003. Should I activate AWE ?
I've just installed an active/active (cluster) SQL server. For information, each node has 4 cpu in Hyperthreading (8 logicals cpu) and 4Go of memory...
What do you mean by 'error handlers' ? I made a trace and i now on which statement it failed !! Thanks for that. Now my problem is that I think this...
I am going to try a trace with SP<img src='/community/emoticons/emotion-7.gif' alt=':S' />tmt_Starting and i'm going to look for the last one. <br...
The problem is that the sproc I want to trace/debug is on the production database !!<br /><br />And i suppose it won't work because we have a named...
Ok i take a look to those articles ! Thks, Marc
Hello, I am new in sql server and i am looking for the way to trace a stored procedure which sometimes failes. I would like to know on which...
Separate names with a comma.
