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 |
|
seal
Starting Member
3 Posts |
 Posted - 2008-10-11 : 01:01:28
|
| Hi all,I have SQL server 2000 sp4 problems after demoting old primary domain controller. Demotion process was performed smoothly and cleanly. The server itself takes about 2 minutes to query a single table against a few seconds prior to demotion pdc.Are there any dependencies between sql server and pdc ?.Cheers, |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-11 : 04:15:31
|
| There is no correlation. The only thing, I can think of is login time if you are using Windows Authentication.Best thing to do is check sysprocesses output when you are selecting from the mentioned table, to see if the process (SPID) is waiting on something/ is being blocked. |
 |
|
|
|
|
|
SQL server 2000 speed impact after changing pdc