Performance of EM

Hi,
I have no large database on my notebook. The only databases that I use for
my tests are Northwind and Pubs. Each time I install Windows and SQL Server,
I notice that EM considerably becomes slow after 1 or 2 months. This is what
all my colleagues complain about. Is it normal?! Is there any solution?
Defragging the disk did not help.
Any help would be greatly appreciated.
Leila"Leila" <Leilas@.hotpop.com> wrote in message
news:urPZ8AOWGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I have no large database on my notebook. The only databases that I use for
> my tests are Northwind and Pubs. Each time I install Windows and SQL
> Server, I notice that EM considerably becomes slow after 1 or 2 months.
> This is what all my colleagues complain about. Is it normal?! Is there any
> solution?
> Defragging the disk did not help.
> Any help would be greatly appreciated.
> Leila
>
Fix your clock.
David|||Check if ODBC tracing is turned on.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Leila" <Leilas@.hotpop.com> wrote in message news:urPZ8AOWGHA.1192@.TK2MSFTNGP03.phx.gbl...[v
bcol=seagreen]
> Hi,
> I have no large database on my notebook. The only databases that I use for
> my tests are Northwind and Pubs. Each time I install Windows and SQL Serve
r,
> I notice that EM considerably becomes slow after 1 or 2 months. This is wh
at
> all my colleagues complain about. Is it normal?! Is there any solution?
> Defragging the disk did not help.
> Any help would be greatly appreciated.
> Leila
>[/vbcol]|||Thanks Tibor,
But this is off. Don't you really have this problem?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u88pJVOWGHA.4768@.TK2MSFTNGP05.phx.gbl...[vbcol=seagreen]
> Check if ODBC tracing is turned on.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:urPZ8AOWGHA.1192@.TK2MSFTNGP03.phx.gbl...|||Thanks David,
But I didn't get it!
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:eccxuEOWGHA.1192@.TK2MSFTNGP03.phx.gbl...
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:urPZ8AOWGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Fix your clock.
> David
>|||Didn't get what? David was NOT addressing your issue of EM performance.
Both David and Aaron have asked you to fix your system clock, which is
causing your posts to be marked with tomorrow's date. Some people do this so
that their posts will show up at the top of the list for longer, and it is
considered very rude. Many very knowledgeable people on these forums will
refuse to answer posts that are post-dated like this. So do yourself a
favor, and make sure your system clock is correct.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:OBJ6AHPWGHA.1192@.TK2MSFTNGP04.phx.gbl...
> Thanks David,
> But I didn't get it!
>
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:eccxuEOWGHA.1192@.TK2MSFTNGP03.phx.gbl...
>|||Leila, do you know where your taskbar is? Do you see a clock there? Can
you please set the proper date?

> Thanks Tibor,
> But this is off. Don't you really have this problem?|||Leila (Leilas@.hotpop.com) writes:
> Date: Thu, 6 Apr 2006 22:08:56 +0430
That moment in time has not occurred yet. That's why people is yelling
at you to fix the clock.

> Thanks Tibor,
> But this is off. Don't you really have this problem?
The other standard thing to look out for is databases that are set to
autoclose. That can be a major peformance hog, if your are not sysadmin,
as EM needs to open each database to check the access rights.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Oh... thanks indeed Kalen!
Honestly I was working on point-in-time recovery and I used the clock to
move the time forward when modifying the data! I did not need to check the
calendar on my notebook (I use my watch!) to fix it since few days ago :-)
I must check if I have made any mistakes on some data entry or timestamps in
my word documents!!
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:O32lhMPWGHA.4920@.TK2MSFTNGP02.phx.gbl...
> Didn't get what? David was NOT addressing your issue of EM performance.
> Both David and Aaron have asked you to fix your system clock, which is
> causing your posts to be marked with tomorrow's date. Some people do this
> so that their posts will show up at the top of the list for longer, and it
> is considered very rude. Many very knowledgeable people on these forums
> will refuse to answer posts that are post-dated like this. So do yourself
> a favor, and make sure your system clock is correct.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:OBJ6AHPWGHA.1192@.TK2MSFTNGP04.phx.gbl...
>|||Oh... thanks indeed Kalen!
Honestly I was working on point-in-time recovery and I used the clock to
move the time forward when modifying the data! I did not need to check the
calendar on my notebook (I use my watch!) to fix it since few days ago :-)
I must check if I have made any mistakes on some data entries (with default
date) or timestamps in
my word documents!!
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:O32lhMPWGHA.4920@.TK2MSFTNGP02.phx.gbl...
> Didn't get what? David was NOT addressing your issue of EM performance.
> Both David and Aaron have asked you to fix your system clock, which is
> causing your posts to be marked with tomorrow's date. Some people do this
> so that their posts will show up at the top of the list for longer, and it
> is considered very rude. Many very knowledgeable people on these forums
> will refuse to answer posts that are post-dated like this. So do yourself
> a favor, and make sure your system clock is correct.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:OBJ6AHPWGHA.1192@.TK2MSFTNGP04.phx.gbl...
>