|
|
|
SSC Veteran
 
Group: General Forum Members
Last Login: Today @ 9:30 AM
Points: 219,
Visits: 694
|
|
Just curious but with the size of data you are keeping how will you keep the database under 4GB, which is the database size limit for SQL Server Express?
------------
Shawn Melton 
Forum Etiquette by Jeff Moden
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 12:13 PM
Points: 16,988,
Visits: 12,113
|
|
Ninja's_RGR'us (10/15/2009)
GilaMonster (10/15/2009)
Ninja's_RGR'us (10/15/2009)
We I mean slowly I mean 10 seconds to record 1 record on a "supposed" index seek, his words not mine.Can you find/get vendor to find the wait type that the query has while running? Agree with Gus, there's no throttle on Express. If it's slower than vendor's laptop there's another reason. Seeing if the query's waiting and, if so, on what would help. How do I do that... I never tuned that way Gail  .
Sorry, assuming that you knew everything. 
SELECT * FROM sys.dm_exec_requests where wait_time > 0 and session_id > 50
That should get you all the queries that are waiting for something. Run that while the 10 sec query is running and you should see if it's waiting for something and, if so, what.
Don't suppose you can get at the execution plan to see if those supposed seeks really are seeks?
p.s. how are you keeping? Haven't seen you around for a while. Coming to PASS this year?
Gail Shaw
We walk in the dark places no others will enter
We stand on the bridge and none may pass
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 4:41 PM
Points: 12,511,
Visits: 2,248
|
|
Melton (10/15/2009)
Just curious but with the size of data you are keeping how will you keep the database under 4GB, which is the database size limit for SQL Server Express?
I already answered that in my 4th post in this thread. I think we have at best 2-3 months before we hit that limit... unless the app is redesigend by some miracle.
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 4:41 PM
Points: 12,511,
Visits: 2,248
|
|
Matt Miller (#4) (10/15/2009)
was his laptop 64-bit by any chance? Because that would allow him to use twice as much RAM for SQL (since SQL could use 4, and the OS could have 4 of its own....)
You've probably thought of this too, but depending on where Express runs, it could be on a drive that gets a lot of activity, or gets virus checked, etc.... i.e. all of those fun things that slow deskto-type OS'es down.
I'll check it out this morning... I had about 5 minutes to troubleshoot this issue before leaving the office. I know very little about that machine aside that it hosts that application.
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 4:41 PM
Points: 12,511,
Visits: 2,248
|
|
GilaMonster (10/16/2009)
Ninja's_RGR'us (10/15/2009)
GilaMonster (10/15/2009)
Ninja's_RGR'us (10/15/2009)
We I mean slowly I mean 10 seconds to record 1 record on a "supposed" index seek, his words not mine.Can you find/get vendor to find the wait type that the query has while running? Agree with Gus, there's no throttle on Express. If it's slower than vendor's laptop there's another reason. Seeing if the query's waiting and, if so, on what would help. How do I do that... I never tuned that way Gail . Sorry, assuming that you knew everything. SELECT * FROM sys.dm_exec_requests where wait_time > 0 and session_id > 50 That should get you all the queries that are waiting for something. Run that while the 10 sec query is running and you should see if it's waiting for something and, if so, what. Don't suppose you can get at the execution plan to see if those supposed seeks really are seeks? p.s. how are you keeping? Haven't seen you around for a while. Coming to PASS this year?
I was working on that in my 5 minutes window. I came across an app that only executes sp_prepared statements and apparently I cannot find any of the source query about that program. Also the only one I could find does a clustered seek, but it's not on the big tables.
1 - Do you think the exec plans could be saved into trace? I think I remember someone talking about that in PASS 2007.
2 - Yes Gail, I do know a lot, especially when I have time to hit up google .
3 - I have no plans of going to PASS this year. I've been busy with building my own business and getting back in shape. I'm still doing a lot of SQL but right now I'm working with Access / SQL SERVER setup.
4 - Does sys.dm_exec_requests caches the results at all? If so I could just run that query this morning. Timing this query with an actual application that actually takes 5-10 seconds might be tricky with only 1 computer in the room.
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 12:13 PM
Points: 16,988,
Visits: 12,113
|
|
Ninja's_RGR'us (10/16/2009)
1 - Do you think the exec plans could be saved into trace? I think I remember someone talking about that in PASS 2007.
Yes, look for the Showplan XML event (under Performance)
4 - Does sys.dm_exec_requests caches the results at all?
No, it shows the currently executing requests only.
Gail Shaw
We walk in the dark places no others will enter
We stand on the bridge and none may pass
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 4:41 PM
Points: 12,511,
Visits: 2,248
|
|
Thanks Gail.
I'll have to close this one with we're going to upgrade to 2008 standard as soon as possible since we'll be forced to at some point. I'm sure I can tune the server a bit more, or a lot. But that's not going to change the faith of this server anyways.
All the best.
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Monday, February 22, 2010 11:36 AM
Points: 44,
Visits: 120
|
|
| Increase the auto growth factor above 1 mb so it doesn't autogrow on every pdf. Get a real version as suggested.
|
|
|
|
|
SSCrazy
Group: General Forum Members
Last Login: Today @ 3:46 PM
Points: 2,377,
Visits: 1,812
|
|
I agree, 1MB is WAY too small, database growing is a synchronous operation, basically everything has to wait until it is done. So you don't want to have to grow very often Can I sell you on 50MB? I just don't like to use % though.
CEWII
--------------------------------
Having trouble figuring out what jobs are running in SQL Server at the same time.
Try Sql Job History Visualization
It lets you view your SQL Job history on an Outlook style calendar..
|
|
|
|
|
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 1:58 PM
Points: 8,582,
Visits: 4,890
|
|
If the database isn't going to remain tiny throughout it's lifespan, I generally start it at 1 Gig and set the growth to 1 Gig. Sure, that sometimes means I'm wasting some disk space, and it can also mean that growth events take longer (when measured in milliseconds), but it also minimizes file fragmentation and growth events. It's worked well as a general rule of thumb for the last few years.
(I have over a Terabyte of storage on my home computer. I don't view 1 Gig as a significant amount of disk space these days.)
- GSquared
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
|
|
|
|
