|
Is it necessary to manually UPDATE STATISTICS for a SQL Server database regularly (e.g. daily) when *AUTO_CREATE_STATISTICS* and *AUTO_UPDATE_STATISTICS* options are ON ?
Started by owlsprt on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Yes you need to ....
If you don't do that, and leave those two options off, then statistics are not updated and query performance will suffer.
Recommended practice is to have the statistics updated every night as part of a maintenance plan.
|
|
Is it possible to get statistics about each users contributions, total line count etc?
Started by REM on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
It can put together graphs and provide all sorts of statistics; including user contributions (Percentage statistics by using "Show Log......
I have used StatSVN.
TortoiseSVN is not capable of gathering statistics (That I'm aware of).
|
|
I know about w3schools statistics, but it much differs from the one on my company's site.
Started by Kamarey on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
That's why useful statistics measure over ....
It all depends on the intended audience.
Http://en.wikipedia.org/wiki/Usage_share_of_web_browsers
The w3schools statistics are not very company's site has different statistics from that.
|
Ask your Facebook Friends
|
Is there any benefit to running an UPDATE Statistics after you create an index or is it done automatically for you?
Started by Abe Miessler on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
WITH STATISTICS_NORECOMPUTE = ON.
If the new index needs new statistics they are automatically created, unless you explictly disable the statistics compute for the new index via CREATE INDEX ...
|
|
I have an instance of SQL Server that I am trying to benchmark. From the SQL Studio application I can type
SET STATISTICS TIME ON
and see outputted statistics after that. From C++ code, I can do something like
SQLExecDirect(hstmt, "SET STATISTICS TIME...
Started by Steven Canfield on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You could try using dbh.func....
Well, it's not going via odbc, but if you have the Sql Server tools, would the Sql Profiler work for you? You can use that to time the execution of statements, transactions, sprocs, and a myriad other things in Sql Server .
|
|
I'm wondering if updating statistics has helped you before and how did you know to update them?
Started by Jon on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
There is also the UPDATE STATISTICS command, but I've personally never used that.....
Exec sp_updatestats
Yes, updating statistics can be very helpful if you find that your queries of this assumes that you have set up your indexes correctly.
|
|
In your experience, how often should Oracle database statistics be run? Our team of developers recently discovered that statistics hadn't been run our production box in over 2 1/2 months. That sounds like a long time to me, but I'm not a DBA.
Started by happyappa on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
Oracle gathers statistics on all database objects automatically....
Statistics store statistics is to allow Oracle to automatically gather the statistics.
To 1000 rows with nearly unique values in column X, that's a significant change .
|
|
Hi folks,
I've got a SQL 2005 database which has some maintenance plans on it set up by someone else. One runs Update Statistics on all databases early in the morning. It seems this is causing tempdb to fill up and hence breaking some other maintenance...
Answer Snippets (Read the full thread at serverfault):
The Update Statistics setting can be disabled - I don't know why you have a separate maintenance task for this though - just keep in mind that you'll need to run UPDATE STATISTICS if you want if the indexes are not fragmented), the statistics....
|
|
What is a good site to check current web usage statistics -- particularly Java version, OS, browser. I have been trying to figure out Google Zeitgeist because it supposedly has this information, but I can't find it.
Started by Jeremy White on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Honestly, your best bet is to take ....
Have you tried www.google.com/analytics/?
Zeitgeist is more a gathering of statistics about source to get detailed browser/OS statistics on the web because it's considered private info by most sites.
|
|
Hi,
How can I access Ethernet statistics from C/C++ code like netstat -e ?
Interface Statistics Received Sent Bytes 21010071 15425579 Unicast packets 95512 94166 Non-unicast packets 12510 7 Discards 0 0 Errors 0 3 Unknown protocols 0
Started by Denes Tarjan on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Pipe the output.
There are a couple on the computer, but can obviously be used to retrieve statistics for remote computers also.
For network statistics would be the GetIpStatistics call in the Windows IPHelper functions.
|
