|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Performance of EMHi,
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" <Lei***@hotpop.com> wrote in message Fix your clock.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 > David Thanks David,
But I didn't get it! Show quote "David Browne" <davidbaxterbrowne no potted m***@hotmail.com> wrote in message news:eccxuEOWGHA.1192@TK2MSFTNGP03.phx.gbl... > > "Leila" <Lei***@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 > 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. Show quote "Leila" <Lei***@hotpop.com> wrote in message news:OBJ6AHPWGHA.1192@TK2MSFTNGP04.phx.gbl... > Thanks David, > But I didn't get it! > > > "David Browne" <davidbaxterbrowne no potted m***@hotmail.com> wrote in > message news:eccxuEOWGHA.1192@TK2MSFTNGP03.phx.gbl... >> >> "Leila" <Lei***@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 >> > > 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!! Show quote "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" <Lei***@hotpop.com> wrote in message > news:OBJ6AHPWGHA.1192@TK2MSFTNGP04.phx.gbl... >> Thanks David, >> But I didn't get it! >> >> >> "David Browne" <davidbaxterbrowne no potted m***@hotmail.com> wrote in >> message news:eccxuEOWGHA.1192@TK2MSFTNGP03.phx.gbl... >>> >>> "Leila" <Lei***@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 >>> >> >> > > 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!! Show quote "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" <Lei***@hotpop.com> wrote in message > news:OBJ6AHPWGHA.1192@TK2MSFTNGP04.phx.gbl... >> Thanks David, >> But I didn't get it! >> >> >> "David Browne" <davidbaxterbrowne no potted m***@hotmail.com> wrote in >> message news:eccxuEOWGHA.1192@TK2MSFTNGP03.phx.gbl... >>> >>> "Leila" <Lei***@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.
-- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Leila" <Lei***@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 > > Thanks Tibor,
But this is off. Don't you really have this problem? Show quote "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:u88pJVOWGHA.4768@TK2MSFTNGP05.phx.gbl... > 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" <Lei***@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 Leila, do you know where your taskbar is? Do you see a clock there? Can
you please set the proper date? Show quote > Thanks Tibor, > But this is off. Don't you really have this problem? Leila (Lei***@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 yellingat you to fix the clock. > Thanks Tibor, The other standard thing to look out for is databases that are set to> But this is off. Don't you really have this problem? 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, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  |
|||||||||||||||||||||||
Other interesting topics