Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2007-04-05 : 22:39:18
|
| Hey Guys, On my scenario, we receive different files from different sources, each source file has its own "ID Assignment" process (using an ETL tool called abinitio), therefore, I can't have process running in parallel and this is becoming an issue, because we growing, creating new products and buying more data and these processes are now taking longer to run and of course, things aren't getting done in time. (That's a "No no" for Sales, especially us that sells data)I would like to know how do you guys handle any ID assignment process on your databases, it's a real pain to manage IDs using files (IDFile, MaxIDFile...) and it got to be a away to handle that to the database server to handle, just wanted to bounce some ideas with other DBAs, let me know what your thoughts or suggestions are on this one.System:3 SQL Servers 20001 SQL Server 20054 Linux Servers (AbInitio)Thanks guys!---"There's no sexy way to carry a lunch bag." My boss |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2007-04-06 : 12:40:43
|
Where does the bottleneck occur?Does it appear to be IO bound? CPU bound?When you run a trace on these stats what are you seeing.I looked at the abinitio website, what level of control do you have over the code in this tool? You can do anything at www.zombo.com |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-04-13 : 15:39:21
|
| The bottlenech occurs where I can only have 1 process running thru the ID assignment process at the time and every record that comes in to our databases needs to pass thru the ID assignment process, if one process fails or gets delayed for any reason, all processes are impacted by the issue.Maybe I wasn't very clear on my question (I'm sure I wasn't), the ID assignment process run on Linux Servers, I was wondering if anyone has anything similar running in SQL 2000/2005, right now we use files to manage the process and I wanted to start making use of databases for this process.Let me know if you have any other questions and thanks for the reply.Igor Santos---"Try not to become a man of success but rather try to become a man of value." |
|
|
|
|
|
|
|
|
ID Management Suggestions