It is taking more than 25 seconds to login

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

It is taking more than 25 seconds to login

Author

Topic

ForceF16
Starting Member

13 Posts

Posted - 2007-01-16 : 09:46:02

Hi,

I recently migrated to Windows 2003 server from W2K server. When I ran a SQL profiler to see how long it takes to log on to the main page. It's taking more than 25 seconds to login (this is a new server with Windows 2003 server). Do you have any idear or suggessions. I would appreciate it.

Thanks,

Dan

dan

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-16 : 09:47:42

Are you still using ODBC as library for connecting?
Or OLE DB, or Native SQL?

Peter Larsson
Helsingborg, Sweden

ForceF16
Starting Member

13 Posts

Posted - 2007-01-16 : 10:14:18

Native SQL. I still keep my old server (W2K server) for back up. It's running faster than the new server (windows 2003 server). It's taking 1 to 3 seconds to login.

Thanks,
Dan

dan

Michael Raven
Starting Member

7 Posts

Posted - 2007-01-18 : 01:34:08

what type of auth are you using? Windows or SQL Server?

ForceF16
Starting Member

13 Posts

Posted - 2007-01-19 : 12:56:12

Windows

dan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources